If possible, can you help in introducing threading to this so that instead of reading servername one by one, it can do that in batches and can save time in...

Quite straight forward. Scored 1 mark.

Use of 0 will delete all .bkp files from the path but I need to delte files older than the date I mentioned,.

Was an easy one. Thnx for the question.

If the question could have been asked to check the returned value:

SELECT Value

FROM #tmpOldValue

WHERE Value NOT IN (SELECT Value FROM #tmpNewValue)

The answer would have been := 6

Got it correct. But Most of the time I have observed that the answer may appear diff in diff cases.

I think inside the begin trans...commit, it all are counted as a single transaction. Hence 1 row is affected.

Microsoft SQL Server 2008 Express edition has a database size limit to 4GB. Microsoft SQL Server 2008 R2 Express edition has a database size limit to 10GB. Microsoft SQL Server...

Great One.

Thnx Wayne. Appreciate your response.

To the Room, this is my final query now..

--1.

DECLARE @sn NVARCHAR(1000);

EXEC master.dbo.xp_regread

'HKEY_LOCAL_MACHINE',

'SYSTEM\CurrentControlSet\services\MSSQLServer',

'ObjectName',

@sn OUTPUT;

SELECT @sn;

--2.

declare @string VARCHAR(4000);

SET @string = 'setspn -L "' + @sn + '"'

select @string

exec xp_cmdshell...

Many thanks, Crystal. Good Day.

IS this a good query to check or do you suggest any other probable best way to find the details? Please suggest

select net_library,loginame,hostname,spid from sysprocesses

where spid > 50 and net_library...

Good Question. Little knowledge on theoretical it needs but a nice question.

Nice Question and got 2 marks.