I urge  posters to provide complete  script from scratch

Without providing table definition and how data is inserted , these kind of posts are highly hypothetical and just academic

Not much use...

I forgot to mention . This is in SQL 2005 SP2

Please stop mumbo jumbo wordings. Options could have been with witness / without witness . I hope testing on concept / technical skill and not on english phrases

Question should be straight forward and clear and should test concepts.

Tricky wording (database files/data files ) should be avoided , which does not make any sense

When I run on my instance (dynamic port) this gives null . Not much use

Following gives the port

declare @tcpport varchar(1000),@value varchar(250);set @tcpport = 'SOFTWARE\Microsoft\Microsoft SQL Server\' +...

Practically this is not possible. In production you can not stop and start the service everyday and changes occur to master datbase every day .

This is a good tool for systeminfo . Do you have a tool to capture sql server information like edition,service pack, cpu affinity mask, memory configured. Now these are...

Since the query is referring to the database in SQL Seerver 2000, when I creaetd the query to call sp_db_mail in SQL 2005 through link server , It...

If you want to send query result using link server approach , you need to create two way link server and provide access to databases in sql 2000 to...

Since TOP supports a variable , add top variable to select with row_number statement to improve performance