Re: XML Datatype Problem - XSL - XML

#1 (**permalink**) 11-07-2008, 12:51 PM

LPJ wrote:

> <S N="Message">SQL Server is not ready to accept new client
> connections. Wait a few minutes before trying again. If you have access to
> the error log, look for the informational message that indicates that SQL
> Server is ready before trying to connect again. [CLIENT: <local machine>]</S>
^^^^^^^^^^^^
That is not well-formed XML.

> <S N="Source">MSSQL$MSSQLSERVER_1</S>
> <Obj N="ReplacementStrings" RefId="RefId-2">
> <TNRef RefId="RefId-2" />
> <LST>
> <S> [CLIENT: <local machine>]</S>
^^^^^^^^^^^^^^^
Nor is that.

> This is a column in my sqls server table, call "valores".. I have 4 lines in
> this table...but you can see i have a lot information inside de XML..i want
> to return this informations...to every line, i have much information in
> XML..how can i do this ?

You can use the nodes function on the XML column. Here is an example:

CREATE TABLE t5 (
valores XML
);
GO
INSERT INTO t5 (valores) VALUES(N'<Objs
xmlns="http://schemas.microsoft.com/powershell/200 4/04" Version="1.1">
<Obj RefId="RefId-0">
<TN RefId="RefId-0">
<T>System.Diagnostics.EventLogEntry</T>
<T>System.ComponentModel.Component</T>
<T>System.MarshalByRefObject</T>
<T>System.Object</T>
</TN>
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">1847</I32>
<S N="Category">Server</S>
<I16 N="CategoryNumber">2</I16>
<I32 N="EventID">9954</I32>
<Obj N="EntryType" RefId="RefId-1">
<TN RefId="RefId-1">
<T>System.Diagnostics.EventLogEntryType</T>
<T>System.Enum</T>
<T>System.ValueType</T>
<T>System.Object</T>
</TN>
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server failed to communicate with filter daemon
launch service (Windows error: O serviço não pode ser iniciado porque está
desativado ou não tem dispositivos ativados associados. ). Full-Text filter
daemon process failed to start. Full-text search functionality will not be
available.</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TN RefId="RefId-2">
<T>System.String[]</T>
<T>System.Array</T>
<T>System.Object</T>
</TN>
<LST>
<S>O serviço não pode ser iniciado porque está desativado ou não
tem dispositivos ativados associados. </S>
</LST>
</Obj>
<I64 N="InstanceId">3221235426</I64>
<DT N="TimeGenerated">2008-10-28T21:37:39-02:00</DT>
<DT N="TimeWritten">2008-10-28T21:37:39-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">2042</I32>
<S N="Category">Logon</S>
<I16 N="CategoryNumber">4</I16>
<I32 N="EventID">17187</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server is not ready to accept new client
connections. Wait a few minutes before trying again. If you have access to
the error log, look for the informational message that indicates that SQL
Server is ready before trying to connect again. [CLIENT: 201.76.81.26]</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S> [CLIENT: 201.76.81.26]</S>
</LST>
</Obj>
<I64 N="InstanceId">3221242659</I64>
<DT N="TimeGenerated">2008-10-30T17:43:42-02:00</DT>
<DT N="TimeWritten">2008-10-30T17:43:42-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">2043</I32>
<S N="Category">Logon</S>
<I16 N="CategoryNumber">4</I16>
<I32 N="EventID">17187</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server is not ready to accept new client
connections. Wait a few minutes before trying again. If you have access to
the error log, look for the informational message that indicates that SQL
Server is ready before trying to connect again. [CLIENT: 201.76.81.26]</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S> [CLIENT: 201.76.81.26]</S>
</LST>
</Obj>
<I64 N="InstanceId">3221242659</I64>
<DT N="TimeGenerated">2008-10-30T17:43:42-02:00</DT>
<DT N="TimeWritten">2008-10-30T17:43:42-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">2060</I32>
<S N="Category">Server</S>
<I16 N="CategoryNumber">2</I16>
<I32 N="EventID">9954</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server failed to communicate with filter daemon
launch service (Windows error: O serviço não pode ser iniciado porque está
desativado ou não tem dispositivos ativados associados. ). Full-Text filter
daemon process failed to start. Full-text search functionality will not be
available.</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>O serviço não pode ser iniciado porque está desativado ou não
tem dispositivos ativados associados. </S>
</LST>
</Obj>
<I64 N="InstanceId">3221235426</I64>
<DT N="TimeGenerated">2008-10-30T17:43:46-02:00</DT>
<DT N="TimeWritten">2008-10-30T17:43:46-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA N="Data" />
<I32 N="Index">2087</I32>
<S N="Category">Gerenciamento</S>
<I16 N="CategoryNumber">5</I16>
<I32 N="EventID">107</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">Report Server Windows Service (MSSQLSERVER_1) não
pode
se conectar ao banco de dados do servidor de relatório.</S>
<S N="Source">Report Server Windows Service (MSSQLSERVER_1)</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>Report Server Windows Service (MSSQLSERVER_1)</S>
</LST>
</Obj>
<I64 N="InstanceId">107</I64>
<DT N="TimeGenerated">2008-10-30T17:44:01-02:00</DT>
<DT N="TimeWritten">2008-10-30T17:44:01-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">2241</I32>
<S N="Category">Server</S>
<I16 N="CategoryNumber">2</I16>
<I32 N="EventID">9954</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server failed to communicate with filter daemon
launch service (Windows error: O serviço não pode ser iniciado porque está
desativado ou não tem dispositivos ativados associados. ). Full-Text filter
daemon process failed to start. Full-text search functionality will not be
available.</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>O serviço não pode ser iniciado porque está desativado ou não
tem dispositivos ativados associados. </S>
</LST>
</Obj>
<I64 N="InstanceId">3221235426</I64>
<DT N="TimeGenerated">2008-11-01T21:30:23-02:00</DT>
<DT N="TimeWritten">2008-11-01T21:30:23-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA N="Data" />
<I32 N="Index">2261</I32>
<S N="Category">Gerenciamento</S>
<I16 N="CategoryNumber">5</I16>
<I32 N="EventID">107</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">Report Server Windows Service (MSSQLSERVER_1) não
pode
se conectar ao banco de dados do servidor de relatório.</S>
<S N="Source">Report Server Windows Service (MSSQLSERVER_1)</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>Report Server Windows Service (MSSQLSERVER_1)</S>
</LST>
</Obj>
<I64 N="InstanceId">107</I64>
<DT N="TimeGenerated">2008-11-01T21:30:30-02:00</DT>
<DT N="TimeWritten">2008-11-01T21:30:30-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">2606</I32>
<S N="Category">Logon</S>
<I16 N="CategoryNumber">4</I16>
<I32 N="EventID">17187</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server is not ready to accept new client
connections. Wait a few minutes before trying again. If you have access to
the error log, look for the informational message that indicates that SQL
Server is ready before trying to connect again. [CLIENT:
200.211.152.48]</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S> [CLIENT: 200.211.152.48]</S>
</LST>
</Obj>
<I64 N="InstanceId">3221242659</I64>
<DT N="TimeGenerated">2008-11-04T07:54:45-02:00</DT>
<DT N="TimeWritten">2008-11-04T07:54:45-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">2607</I32>
<S N="Category">Logon</S>
<I16 N="CategoryNumber">4</I16>
<I32 N="EventID">17187</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server is not ready to accept new client
connections. Wait a few minutes before trying again. If you have access to
the error log, look for the informational message that indicates that SQL
Server is ready before trying to connect again. [CLIENT:
200.211.152.48]</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S> [CLIENT: 200.211.152.48]</S>
</LST>
</Obj>
<I64 N="InstanceId">3221242659</I64>
<DT N="TimeGenerated">2008-11-04T07:54:45-02:00</DT>
<DT N="TimeWritten">2008-11-04T07:54:45-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">2620</I32>
<S N="Category">Server</S>
<I16 N="CategoryNumber">2</I16>
<I32 N="EventID">9954</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server failed to communicate with filter daemon
launch service (Windows error: O serviço não pode ser iniciado porque está
desativado ou não tem dispositivos ativados associados. ). Full-Text filter
daemon process failed to start. Full-text search functionality will not be
available.</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>O serviço não pode ser iniciado porque está desativado ou não
tem dispositivos ativados associados. </S>
</LST>
</Obj>
<I64 N="InstanceId">3221235426</I64>
<DT N="TimeGenerated">2008-11-04T07:54:46-02:00</DT>
<DT N="TimeWritten">2008-11-04T07:54:46-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA N="Data" />
<I32 N="Index">2632</I32>
<S N="Category">Gerenciamento</S>
<I16 N="CategoryNumber">5</I16>
<I32 N="EventID">107</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">Report Server Windows Service (MSSQLSERVER_1) não
pode
se conectar ao banco de dados do servidor de relatório.</S>
<S N="Source">Report Server Windows Service (MSSQLSERVER_1)</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>Report Server Windows Service (MSSQLSERVER_1)</S>
</LST>
</Obj>
<I64 N="InstanceId">107</I64>
<DT N="TimeGenerated">2008-11-04T07:54:47-02:00</DT>
<DT N="TimeWritten">2008-11-04T07:54:47-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">2786</I32>
<S N="Category">Logon</S>
<I16 N="CategoryNumber">4</I16>
<I32 N="EventID">17187</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server is not ready to accept new client
connections. Wait a few minutes before trying again. If you have access to
the error log, look for the informational message that indicates that SQL
Server is ready before trying to connect again. </S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S> </S>
</LST>
</Obj>
<I64 N="InstanceId">3221242659</I64>
<DT N="TimeGenerated">2008-11-04T08:34:47-02:00</DT>
<DT N="TimeWritten">2008-11-04T08:34:47-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">2797</I32>
<S N="Category">Server</S>
<I16 N="CategoryNumber">2</I16>
<I32 N="EventID">9954</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server failed to communicate with filter daemon
launch service (Windows error: O serviço não pode ser iniciado porque está
desativado ou não tem dispositivos ativados associados. ). Full-Text filter
daemon process failed to start. Full-text search functionality will not be
available.</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>O serviço não pode ser iniciado porque está desativado ou não
tem dispositivos ativados associados. </S>
</LST>
</Obj>
<I64 N="InstanceId">3221235426</I64>
<DT N="TimeGenerated">2008-11-04T08:34:50-02:00</DT>
<DT N="TimeWritten">2008-11-04T08:34:50-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA N="Data" />
<I32 N="Index">2807</I32>
<S N="Category">Gerenciamento</S>
<I16 N="CategoryNumber">5</I16>
<I32 N="EventID">107</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">Report Server Windows Service (MSSQLSERVER_1) não
pode
se conectar ao banco de dados do servidor de relatório.</S>
<S N="Source">Report Server Windows Service (MSSQLSERVER_1)</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>Report Server Windows Service (MSSQLSERVER_1)</S>
</LST>
</Obj>
<I64 N="InstanceId">107</I64>
<DT N="TimeGenerated">2008-11-04T08:34:50-02:00</DT>
<DT N="TimeWritten">2008-11-04T08:34:50-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">3185</I32>
<S N="Category">Logon</S>
<I16 N="CategoryNumber">4</I16>
<I32 N="EventID">17187</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server is not ready to accept new client
connections. Wait a few minutes before trying again. If you have access to
the error log, look for the informational message that indicates that SQL
Server is ready before trying to connect again. </S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S> [CLIENT: ]</S>
</LST>
</Obj>
<I64 N="InstanceId">3221242659</I64>
<DT N="TimeGenerated">2008-11-06T13:33:42-02:00</DT>
<DT N="TimeWritten">2008-11-06T13:33:42-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA
N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
<I32 N="Index">3196</I32>
<S N="Category">Server</S>
<I16 N="CategoryNumber">2</I16>
<I32 N="EventID">9954</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">SQL Server failed to communicate with filter daemon
launch service (Windows error: O serviço não pode ser iniciado porque está
desativado ou não tem dispositivos ativados associados. ). Full-Text filter
daemon process failed to start. Full-text search functionality will not be
available.</S>
<S N="Source">MSSQL$MSSQLSERVER_1</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>O serviço não pode ser iniciado porque está desativado ou não
tem dispositivos ativados associados. </S>
</LST>
</Obj>
<I64 N="InstanceId">3221235426</I64>
<DT N="TimeGenerated">2008-11-06T13:33:42-02:00</DT>
<DT N="TimeWritten">2008-11-06T13:33:42-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
<Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />
<Props>
<S N="MachineName">WINDOWS-6D9049D</S>
<BA N="Data" />
<I32 N="Index">3208</I32>
<S N="Category">Gerenciamento</S>
<I16 N="CategoryNumber">5</I16>
<I32 N="EventID">107</I32>
<Obj N="EntryType" RefId="RefId-1">
<TNRef RefId="RefId-1" />
<ToString>Error</ToString>
<I32>1</I32>
</Obj>
<S N="Message">Report Server Windows Service (MSSQLSERVER_1) não
pode
se conectar ao banco de dados do servidor de relatório.</S>
<S N="Source">Report Server Windows Service (MSSQLSERVER_1)</S>
<Obj N="ReplacementStrings" RefId="RefId-2">
<TNRef RefId="RefId-2" />
<LST>
<S>Report Server Windows Service (MSSQLSERVER_1)</S>
</LST>
</Obj>
<I64 N="InstanceId">107</I64>
<DT N="TimeGenerated">2008-11-06T13:33:43-02:00</DT>
<DT N="TimeWritten">2008-11-06T13:33:43-02:00</DT>
<Nil N="UserName" />
<Nil N="Site" />
<Nil N="Container" />
</Props>
</Obj>
</Objs>');

GO

WITH XMLNAMESPACES (DEFAULT
'http://schemas.microsoft.com/powershell/2004/04')
SELECT
T.obj.value('(Props/S[@N = "MachineName"])[1]', 'nvarchar(20)') AS
MachineName
FROM t5 CROSS APPLY t5.valores.nodes('/Objs/Obj') AS T(obj);

Results looks as follows:

WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
WINDOWS-6D9049D
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

#2 (**permalink**) 11-07-2008, 01:40 PM

Yeahhhh Martin..this is what i need..Thanks Again

"Martin Honnen" wrote:

> LPJ wrote:
>
> > <S N="Message">SQL Server is not ready to accept new client
> > connections. Wait a few minutes before trying again. If you have access to
> > the error log, look for the informational message that indicates that SQL
> > Server is ready before trying to connect again. [CLIENT: <local machine>]</S>
> ^^^^^^^^^^^^
> That is not well-formed XML.
>
> > <S N="Source">MSSQL$MSSQLSERVER_1</S>
> > <Obj N="ReplacementStrings" RefId="RefId-2">
> > <TNRef RefId="RefId-2" />
> > <LST>
> > <S> [CLIENT: <local machine>]</S>
> ^^^^^^^^^^^^^^^
> Nor is that.
>
>
>
> > This is a column in my sqls server table, call "valores".. I have 4 lines in
> > this table...but you can see i have a lot information inside de XML..i want
> > to return this informations...to every line, i have much information in
> > XML..how can i do this ?
>
> You can use the nodes function on the XML column. Here is an example:
>
> CREATE TABLE t5 (
> valores XML
> );
> GO
> INSERT INTO t5 (valores) VALUES(N'<Objs
> xmlns="http://schemas.microsoft.com/powershell/200 4/04" Version="1.1">
> <Obj RefId="RefId-0">
> <TN RefId="RefId-0">
> <T>System.Diagnostics.EventLogEntry</T>
> <T>System.ComponentModel.Component</T>
> <T>System.MarshalByRefObject</T>
> <T>System.Object</T>
> </TN>
> <Props>
> <S N="MachineName">WINDOWS-6D9049D</S>
> <BA
> N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> <I32 N="Index">1847</I32>
> <S N="Category">Server</S>
> <I16 N="CategoryNumber">2</I16>
> <I32 N="EventID">9954</I32>
> <Obj N="EntryType" RefId="RefId-1">
> <TN RefId="RefId-1">
> <T>System.Diagnostics.EventLogEntryType</T>
> <T>System.Enum</T>
> <T>System.ValueType</T>
> <T>System.Object</T>
> </TN>
> <ToString>Error</ToString>
> <I32>1</I32>
> </Obj>
> <S N="Message">SQL Server failed to communicate with filter daemon
> launch service (Windows error: O serviço não pode ser iniciado porque está
> desativado ou não tem dispositivos ativados associados. ). Full-Text filter
> daemon process failed to start. Full-text search functionality will not be
> available.</S>
> <S N="Source">MSSQL$MSSQLSERVER_1</S>
> <Obj N="ReplacementStrings" RefId="RefId-2">
> <TN RefId="RefId-2">
> <T>System.String[]</T>
> <T>System.Array</T>
> <T>System.Object</T>
> </TN>
> <LST>
> <S>O serviço não pode ser iniciado porque está desativado ou não
> tem dispositivos ativados associados. </S>
> </LST>
> </Obj>
> <I64 N="InstanceId">3221235426</I64>
> <DT N="TimeGenerated">2008-10-28T21:37:39-02:00</DT>
> <DT N="TimeWritten">2008-10-28T21:37:39-02:00</DT>
> <Nil N="UserName" />
> <Nil N="Site" />
> <Nil N="Container" />
> </Props>
> </Obj>
> <Obj RefId="RefId-0">
> <TNRef RefId="RefId-0" />
> <Props>
> <S N="MachineName">WINDOWS-6D9049D</S>
> <BA
> N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> <I32 N="Index">2042</I32>
> <S N="Category">Logon</S>
> <I16 N="CategoryNumber">4</I16>
> <I32 N="EventID">17187</I32>
> <Obj N="EntryType" RefId="RefId-1">
> <TNRef RefId="RefId-1" />
> <ToString>Error</ToString>
> <I32>1</I32>
> </Obj>
> <S N="Message">SQL Server is not ready to accept new client
> connections. Wait a few minutes before trying again. If you have access to
> the error log, look for the informational message that indicates that SQL
> Server is ready before trying to connect again. [CLIENT: 201.76.81.26]</S>
> <S N="Source">MSSQL$MSSQLSERVER_1</S>
> <Obj N="ReplacementStrings" RefId="RefId-2">
> <TNRef RefId="RefId-2" />
> <LST>
> <S> [CLIENT: 201.76.81.26]</S>
> </LST>
> </Obj>
> <I64 N="InstanceId">3221242659</I64>
> <DT N="TimeGenerated">2008-10-30T17:43:42-02:00</DT>
> <DT N="TimeWritten">2008-10-30T17:43:42-02:00</DT>
> <Nil N="UserName" />
> <Nil N="Site" />
> <Nil N="Container" />
> </Props>
> </Obj>
> <Obj RefId="RefId-0">
> <TNRef RefId="RefId-0" />
> <Props>
> <S N="MachineName">WINDOWS-6D9049D</S>
> <BA
> N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> <I32 N="Index">2043</I32>
> <S N="Category">Logon</S>
> <I16 N="CategoryNumber">4</I16>
> <I32 N="EventID">17187</I32>
> <Obj N="EntryType" RefId="RefId-1">
> <TNRef RefId="RefId-1" />
> <ToString>Error</ToString>
> <I32>1</I32>
> </Obj>
> <S N="Message">SQL Server is not ready to accept new client
> connections. Wait a few minutes before trying again. If you have access to
> the error log, look for the informational message that indicates that SQL
> Server is ready before trying to connect again. [CLIENT: 201.76.81.26]</S>
> <S N="Source">MSSQL$MSSQLSERVER_1</S>
> <Obj N="ReplacementStrings" RefId="RefId-2">
> <TNRef RefId="RefId-2" />
> <LST>
> <S> [CLIENT: 201.76.81.26]</S>
> </LST>
> </Obj>
> <I64 N="InstanceId">3221242659</I64>
> <DT N="TimeGenerated">2008-10-30T17:43:42-02:00</DT>
> <DT N="TimeWritten">2008-10-30T17:43:42-02:00</DT>
> <Nil N="UserName" />
> <Nil N="Site" />
> <Nil N="Container" />
> </Props>
> </Obj>
> <Obj RefId="RefId-0">
> <TNRef RefId="RefId-0" />
> <Props>
> <S N="MachineName">WINDOWS-6D9049D</S>
> <BA
> N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> <I32 N="Index">2060</I32>
> <S N="Category">Server</S>
> <I16 N="CategoryNumber">2</I16>
> <I32 N="EventID">9954</I32>
> <Obj N="EntryType" RefId="RefId-1">
> <TNRef RefId="RefId-1" />
> <ToString>Error</ToString>
> <I32>1</I32>
> </Obj>
> <S N="Message">SQL Server failed to communicate with filter daemon
> launch service (Windows error: O serviço não pode ser iniciado porque está
> desativado ou não tem dispositivos ativados associados. ). Full-Text filter
> daemon process failed to start. Full-text search functionality will not be
> available.</S>
> <S N="Source">MSSQL$MSSQLSERVER_1</S>
> <Obj N="ReplacementStrings" RefId="RefId-2">
> <TNRef RefId="RefId-2" />
> <LST>
> <S>O serviço não pode ser iniciado porque está desativado ou não
> tem dispositivos ativados associados. </S>
> </LST>
> </Obj>
> <I64 N="InstanceId">3221235426</I64>
> <DT N="TimeGenerated">2008-10-30T17:43:46-02:00</DT>
> <DT N="TimeWritten">2008-10-30T17:43:46-02:00</DT>
> <Nil N="UserName" />
> <Nil N="Site" />
> <Nil N="Container" />
> </Props>
> </Obj>
> <Obj RefId="RefId-0">
> <TNRef RefId="RefId-0" />
> <Props>
> <S N="MachineName">WINDOWS-6D9049D</S>
> <BA N="Data" />
> <I32 N="Index">2087</I32>
> <S N="Category">Gerenciamento</S>
> <I16 N="CategoryNumber">5</I16>
> <I32 N="EventID">107</I32>
> <Obj N="EntryType" RefId="RefId-1">
> <TNRef RefId="RefId-1" />
> <ToString>Error</ToString>
> <I32>1</I32>
> </Obj>
> <S N="Message">Report Server Windows Service (MSSQLSERVER_1) não
> pode
> se conectar ao banco de dados do servidor de relatório.</S>
> <S N="Source">Report Server Windows Service (MSSQLSERVER_1)</S>
> <Obj N="ReplacementStrings" RefId="RefId-2">
> <TNRef RefId="RefId-2" />
> <LST>
> <S>Report Server Windows Service (MSSQLSERVER_1)</S>
> </LST>
> </Obj>
> <I64 N="InstanceId">107</I64>
> <DT N="TimeGenerated">2008-10-30T17:44:01-02:00</DT>
> <DT N="TimeWritten">2008-10-30T17:44:01-02:00</DT>
> <Nil N="UserName" />
> <Nil N="Site" />
> <Nil N="Container" />
> </Props>
> </Obj>
> <Obj RefId="RefId-0">
> <TNRef RefId="RefId-0" />
> <Props>
> <S N="MachineName">WINDOWS-6D9049D</S>
> <BA
> N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> <I32 N="Index">2241</I32>
> <S N="Category">Server</S>
> <I16 N="CategoryNumber">2</I16>
> <I32 N="EventID">9954</I32>
> <Obj N="EntryType" RefId="RefId-1">
> <TNRef RefId="RefId-1" />
> <ToString>Error</ToString>
> <I32>1</I32>
> </Obj>
> <S N="Message">SQL Server failed to communicate with filter daemon
> launch service (Windows error: O serviço não pode ser iniciado porque está
> desativado ou não tem dispositivos ativados associados. ). Full-Text filter
> daemon process failed to start. Full-text search functionality will not be
> available.</S>
> <S N="Source">MSSQL$MSSQLSERVER_1</S>
> <Obj N="ReplacementStrings" RefId="RefId-2">
> <TNRef RefId="RefId-2" />
> <LST>
> <S>O serviço não pode ser iniciado porque está desativado ou não
> tem dispositivos ativados associados. </S>
> </LST>
> </Obj>
> <I64 N="InstanceId">3221235426</I64>
> <DT N="TimeGenerated">2008-11-01T21:30:23-02:00</DT>
> <DT N="TimeWritten">2008-11-01T21:30:23-02:00</DT>
> <Nil N="UserName" />
> <Nil N="Site" />
> <Nil N="Container" />
> </Props>
> </Obj>
> <Obj RefId="RefId-0">
> <TNRef RefId="RefId-0" />
> <Props>
> <S N="MachineName">WINDOWS-6D9049D</S>
> <BA N="Data" />
> <I32 N="Index">2261</I32>
> <S N="Category">Gerenciamento</S>
> <I16 N="CategoryNumber">5</I16>
> <I32 N="EventID">107</I32>
> <Obj N="EntryType" RefId="RefId-1">
> <TNRef RefId="RefId-1" />
> <ToString>Error</ToString>
> <I32>1</I32>
> </Obj>
> <S N="Message">Report Server Windows Service (MSSQLSERVER_1) não
> pode
> se conectar ao banco de dados do servidor de relatório.</S>
> <S N="Source">Report Server Windows Service (MSSQLSERVER_1)</S>
> <Obj N="ReplacementStrings" RefId="RefId-2">
> <TNRef RefId="RefId-2" />
> <LST>
> <S>Report Server Windows Service (MSSQLSERVER_1)</S>
> </LST>
> </Obj>
> <I64 N="InstanceId">107</I64>
> <DT N="TimeGenerated">2008-11-01T21:30:30-02:00</DT>
> <DT N="TimeWritten">2008-11-01T21:30:30-02:00</DT>
> <Nil N="UserName" />
> <Nil N="Site" />
> <Nil N="Container" />
> </Props>
> </Obj>
> <Obj RefId="RefId-0">
> <TNRef RefId="RefId-0" />
> <Props>
> <S N="MachineName">WINDOWS-6D9049D</S>
> <BA
> N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> <I32 N="Index">2606</I32>
> <S N="Category">Logon</S>
> <I16 N="CategoryNumber">4</I16>
> <I32 N="EventID">17187</I32>
> <Obj N="EntryType" RefId="RefId-1">
> <TNRef RefId="RefId-1" />
> <ToString>Error</ToString>
> <I32>1</I32>

#3 (**permalink**) 11-07-2008, 01:41 PM

Martin,

If i do what you did, copy the xml and create a new tabel and insert..its
works...But in my real table doesnt. Nothing appears
I copy the table to another..not works too
What possible happened ?

"LPJ" wrote:

> Yeahhhh Martin..this is what i need..Thanks Again
>
> "Martin Honnen" wrote:
>
> > LPJ wrote:
> >
> > > <S N="Message">SQL Server is not ready to accept new client
> > > connections. Wait a few minutes before trying again. If you have access to
> > > the error log, look for the informational message that indicates that SQL
> > > Server is ready before trying to connect again. [CLIENT: <local machine>]</S>
> > ^^^^^^^^^^^^
> > That is not well-formed XML.
> >
> > > <S N="Source">MSSQL$MSSQLSERVER_1</S>
> > > <Obj N="ReplacementStrings" RefId="RefId-2">
> > > <TNRef RefId="RefId-2" />
> > > <LST>
> > > <S> [CLIENT: <local machine>]</S>
> > ^^^^^^^^^^^^^^^
> > Nor is that.
> >
> >
> >
> > > This is a column in my sqls server table, call "valores".. I have 4 lines in
> > > this table...but you can see i have a lot information inside de XML..i want
> > > to return this informations...to every line, i have much information in
> > > XML..how can i do this ?
> >
> > You can use the nodes function on the XML column. Here is an example:
> >
> > CREATE TABLE t5 (
> > valores XML
> > );
> > GO
> > INSERT INTO t5 (valores) VALUES(N'<Objs
> > xmlns="http://schemas.microsoft.com/powershell/200 4/04" Version="1.1">
> > <Obj RefId="RefId-0">
> > <TN RefId="RefId-0">
> > <T>System.Diagnostics.EventLogEntry</T>
> > <T>System.ComponentModel.Component</T>
> > <T>System.MarshalByRefObject</T>
> > <T>System.Object</T>
> > </TN>
> > <Props>
> > <S N="MachineName">WINDOWS-6D9049D</S>
> > <BA
> > N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> > <I32 N="Index">1847</I32>
> > <S N="Category">Server</S>
> > <I16 N="CategoryNumber">2</I16>
> > <I32 N="EventID">9954</I32>
> > <Obj N="EntryType" RefId="RefId-1">
> > <TN RefId="RefId-1">
> > <T>System.Diagnostics.EventLogEntryType</T>
> > <T>System.Enum</T>
> > <T>System.ValueType</T>
> > <T>System.Object</T>
> > </TN>
> > <ToString>Error</ToString>
> > <I32>1</I32>
> > </Obj>
> > <S N="Message">SQL Server failed to communicate with filter daemon
> > launch service (Windows error: O serviço não pode ser iniciado porque está
> > desativado ou não tem dispositivos ativados associados. ). Full-Text filter
> > daemon process failed to start. Full-text search functionality will not be
> > available.</S>
> > <S N="Source">MSSQL$MSSQLSERVER_1</S>
> > <Obj N="ReplacementStrings" RefId="RefId-2">
> > <TN RefId="RefId-2">
> > <T>System.String[]</T>
> > <T>System.Array</T>
> > <T>System.Object</T>
> > </TN>
> > <LST>
> > <S>O serviço não pode ser iniciado porque está desativado ou não
> > tem dispositivos ativados associados. </S>
> > </LST>
> > </Obj>
> > <I64 N="InstanceId">3221235426</I64>
> > <DT N="TimeGenerated">2008-10-28T21:37:39-02:00</DT>
> > <DT N="TimeWritten">2008-10-28T21:37:39-02:00</DT>
> > <Nil N="UserName" />
> > <Nil N="Site" />
> > <Nil N="Container" />
> > </Props>
> > </Obj>
> > <Obj RefId="RefId-0">
> > <TNRef RefId="RefId-0" />
> > <Props>
> > <S N="MachineName">WINDOWS-6D9049D</S>
> > <BA
> > N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> > <I32 N="Index">2042</I32>
> > <S N="Category">Logon</S>
> > <I16 N="CategoryNumber">4</I16>
> > <I32 N="EventID">17187</I32>
> > <Obj N="EntryType" RefId="RefId-1">
> > <TNRef RefId="RefId-1" />
> > <ToString>Error</ToString>
> > <I32>1</I32>
> > </Obj>
> > <S N="Message">SQL Server is not ready to accept new client
> > connections. Wait a few minutes before trying again. If you have access to
> > the error log, look for the informational message that indicates that SQL
> > Server is ready before trying to connect again. [CLIENT: 201.76.81.26]</S>
> > <S N="Source">MSSQL$MSSQLSERVER_1</S>
> > <Obj N="ReplacementStrings" RefId="RefId-2">
> > <TNRef RefId="RefId-2" />
> > <LST>
> > <S> [CLIENT: 201.76.81.26]</S>
> > </LST>
> > </Obj>
> > <I64 N="InstanceId">3221242659</I64>
> > <DT N="TimeGenerated">2008-10-30T17:43:42-02:00</DT>
> > <DT N="TimeWritten">2008-10-30T17:43:42-02:00</DT>
> > <Nil N="UserName" />
> > <Nil N="Site" />
> > <Nil N="Container" />
> > </Props>
> > </Obj>
> > <Obj RefId="RefId-0">
> > <TNRef RefId="RefId-0" />
> > <Props>
> > <S N="MachineName">WINDOWS-6D9049D</S>
> > <BA
> > N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> > <I32 N="Index">2043</I32>
> > <S N="Category">Logon</S>
> > <I16 N="CategoryNumber">4</I16>
> > <I32 N="EventID">17187</I32>
> > <Obj N="EntryType" RefId="RefId-1">
> > <TNRef RefId="RefId-1" />
> > <ToString>Error</ToString>
> > <I32>1</I32>
> > </Obj>
> > <S N="Message">SQL Server is not ready to accept new client
> > connections. Wait a few minutes before trying again. If you have access to
> > the error log, look for the informational message that indicates that SQL
> > Server is ready before trying to connect again. [CLIENT: 201.76.81.26]</S>
> > <S N="Source">MSSQL$MSSQLSERVER_1</S>
> > <Obj N="ReplacementStrings" RefId="RefId-2">
> > <TNRef RefId="RefId-2" />
> > <LST>
> > <S> [CLIENT: 201.76.81.26]</S>
> > </LST>
> > </Obj>
> > <I64 N="InstanceId">3221242659</I64>
> > <DT N="TimeGenerated">2008-10-30T17:43:42-02:00</DT>
> > <DT N="TimeWritten">2008-10-30T17:43:42-02:00</DT>
> > <Nil N="UserName" />
> > <Nil N="Site" />
> > <Nil N="Container" />
> > </Props>
> > </Obj>
> > <Obj RefId="RefId-0">
> > <TNRef RefId="RefId-0" />
> > <Props>
> > <S N="MachineName">WINDOWS-6D9049D</S>
> > <BA
> > N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> > <I32 N="Index">2060</I32>
> > <S N="Category">Server</S>
> > <I16 N="CategoryNumber">2</I16>
> > <I32 N="EventID">9954</I32>
> > <Obj N="EntryType" RefId="RefId-1">
> > <TNRef RefId="RefId-1" />
> > <ToString>Error</ToString>
> > <I32>1</I32>
> > </Obj>
> > <S N="Message">SQL Server failed to communicate with filter daemon
> > launch service (Windows error: O serviço não pode ser iniciado porque está
> > desativado ou não tem dispositivos ativados associados. ). Full-Text filter
> > daemon process failed to start. Full-text search functionality will not be
> > available.</S>
> > <S N="Source">MSSQL$MSSQLSERVER_1</S>
> > <Obj N="ReplacementStrings" RefId="RefId-2">
> > <TNRef RefId="RefId-2" />
> > <LST>
> > <S>O serviço não pode ser iniciado porque está desativado ou não
> > tem dispositivos ativados associados. </S>
> > </LST>
> > </Obj>
> > <I64 N="InstanceId">3221235426</I64>
> > <DT N="TimeGenerated">2008-10-30T17:43:46-02:00</DT>
> > <DT N="TimeWritten">2008-10-30T17:43:46-02:00</DT>
> > <Nil N="UserName" />
> > <Nil N="Site" />
> > <Nil N="Container" />
> > </Props>
> > </Obj>
> > <Obj RefId="RefId-0">
> > <TNRef RefId="RefId-0" />
> > <Props>
> > <S N="MachineName">WINDOWS-6D9049D</S>
> > <BA N="Data" />
> > <I32 N="Index">2087</I32>
> > <S N="Category">Gerenciamento</S>
> > <I16 N="CategoryNumber">5</I16>
> > <I32 N="EventID">107</I32>
> > <Obj N="EntryType" RefId="RefId-1">
> > <TNRef RefId="RefId-1" />
> > <ToString>Error</ToString>
> > <I32>1</I32>
> > </Obj>
> > <S N="Message">Report Server Windows Service (MSSQLSERVER_1) não
> > pode
> > se conectar ao banco de dados do servidor de relatório.</S>
> > <S N="Source">Report Server Windows Service (MSSQLSERVER_1)</S>
> > <Obj N="ReplacementStrings" RefId="RefId-2">
> > <TNRef RefId="RefId-2" />
> > <LST>
> > <S>Report Server Windows Service (MSSQLSERVER_1)</S>
> > </LST>
> > </Obj>
> > <I64 N="InstanceId">107</I64>
> > <DT N="TimeGenerated">2008-10-30T17:44:01-02:00</DT>
> > <DT N="TimeWritten">2008-10-30T17:44:01-02:00</DT>
> > <Nil N="UserName" />
> > <Nil N="Site" />
> > <Nil N="Container" />
> > </Props>
> > </Obj>
> > <Obj RefId="RefId-0">
> > <TNRef RefId="RefId-0" />
> > <Props>
> > <S N="MachineName">WINDOWS-6D9049D</S>
> > <BA
> > N="Data">4iYAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> > <I32 N="Index">2241</I32>
> > <S N="Category">Server</S>
> > <I16 N="CategoryNumber">2</I16>
> > <I32 N="EventID">9954</I32>
> > <Obj N="EntryType" RefId="RefId-1">
> > <TNRef RefId="RefId-1" />
> > <ToString>Error</ToString>
> > <I32>1</I32>
> > </Obj>
> > <S N="Message">SQL Server failed to communicate with filter daemon
> > launch service (Windows error: O serviço não pode ser iniciado porque está
> > desativado ou não tem dispositivos ativados associados. ). Full-Text filter
> > daemon process failed to start. Full-text search functionality will not be
> > available.</S>
> > <S N="Source">MSSQL$MSSQLSERVER_1</S>
> > <Obj N="ReplacementStrings" RefId="RefId-2">
> > <TNRef RefId="RefId-2" />
> > <LST>
> > <S>O serviço não pode ser iniciado porque está desativado ou não
> > tem dispositivos ativados associados. </S>
> > </LST>
> > </Obj>
> > <I64 N="InstanceId">3221235426</I64>
> > <DT N="TimeGenerated">2008-11-01T21:30:23-02:00</DT>
> > <DT N="TimeWritten">2008-11-01T21:30:23-02:00</DT>
> > <Nil N="UserName" />
> > <Nil N="Site" />
> > <Nil N="Container" />
> > </Props>
> > </Obj>
> > <Obj RefId="RefId-0">
> > <TNRef RefId="RefId-0" />
> > <Props>
> > <S N="MachineName">WINDOWS-6D9049D</S>
> > <BA N="Data" />
> > <I32 N="Index">2261</I32>
> > <S N="Category">Gerenciamento</S>
> > <I16 N="CategoryNumber">5</I16>
> > <I32 N="EventID">107</I32>
> > <Obj N="EntryType" RefId="RefId-1">
> > <TNRef RefId="RefId-1" />
> > <ToString>Error</ToString>
> > <I32>1</I32>
> > </Obj>
> > <S N="Message">Report Server Windows Service (MSSQLSERVER_1) não
> > pode
> > se conectar ao banco de dados do servidor de relatório.</S>
> > <S N="Source">Report Server Windows Service (MSSQLSERVER_1)</S>
> > <Obj N="ReplacementStrings" RefId="RefId-2">
> > <TNRef RefId="RefId-2" />
> > <LST>
> > <S>Report Server Windows Service (MSSQLSERVER_1)</S>
> > </LST>
> > </Obj>
> > <I64 N="InstanceId">107</I64>
> > <DT N="TimeGenerated">2008-11-01T21:30:30-02:00</DT>
> > <DT N="TimeWritten">2008-11-01T21:30:30-02:00</DT>
> > <Nil N="UserName" />
> > <Nil N="Site" />
> > <Nil N="Container" />
> > </Props>
> > </Obj>
> > <Obj RefId="RefId-0">
> > <TNRef RefId="RefId-0" />
> > <Props>
> > <S N="MachineName">WINDOWS-6D9049D</S>
> > <BA
> > N="Data">I0MAABAAAAAeAAAAVwBJAE4ARABPAFcAUwAtADYAR AA5ADAANAA5AEQAXABNAFMAUwBRAEwAUwBFAFIAVgBFAFIAXwA xAAAAAAAAAA==</BA>
> > <I32 N="Index">2606</I32>
> > <S N="Category">Logon</S>
> > <I16 N="CategoryNumber">4</I16>
> > <I32 N="EventID">17187</I32>

#4 (**permalink**) 11-07-2008, 02:49 PM

LPJ wrote:

> If i do what you did, copy the xml and create a new tabel and insert..its
> works...But in my real table doesnt. Nothing appears
> I copy the table to another..not works too
> What possible happened ?

I don't know. Show us the table definition and your query then we can
hopefully say more.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

#5 (**permalink**) 11-07-2008, 03:23 PM

LPJ wrote:

> CREATE TABLE [Diario].[eventlog](
> [servidor] [varchar](50) NULL,
> [data] [datetime] NULL,
> [valores] [xml] NULL
> ) ON [PRIMARY]

So that is the table definition.
How does the exact query look that does not return any results?

> This table contains server, date and the xml. The xml contains the
> information about every server eventviewer what found the word
> "error|warning" and the soucer is "*SQL*".....sql server errors events.. This
> informations i take up with powershell scripts..the inputs made in PS scripts
>
> I input the XML with "insert into" in this table..like you did..and works
> too..but if use the script not works.. I think is something when insert by PS
> script...but i take the XML manually inputed and XML PS inputed...are
> identical...

Well there must be a difference, we just need to find it.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/