I am trying to run following query -

DECLARE @IP NVARCHAR(15);

SET @IP = (SELECT EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'NVARCHAR(15)'));

Select @IP

It is returning Null. Am I doing something wrong ?

Good question!!!

It is not mainly for comma seperated column name. It can be use when you want comma seperated data on grouping of some other field. Please see the output resultset...

Please check if following statement is missing from your script -

Alter Table TestTable Add ColRowNo int

if it is missing, then add it next to statement "select * from TestTable"

it...

You can drop the index on this table. Then insert the data and recreate the index. It will reduce the time of index update durig insert.

Hi,

You can use it by creating Linked server. Another way is openquery and opendatasource functions.

hi,

you can give instance name to install different sql versions on same machine.

Hi

You can use import data wizard in sql server.

Thanks

You can run this query using brackets as -

backup log [DDT-20071007] with truncate_only

Hope it will work.