Tracer tokens comes to your rescue. Read about one such procedure mentioned by Chad at http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/10/24/monitoring-replication-latency-automatically-using-tracer-tokens-sp-replchecklatency-allpubs.aspx.

HTH!

MJ

i believe i saw thread which stated that openquery against a linked server was faster for a linked server vs a query on your server using 4 partnaming conventions;

for example,...

Thanks for the Explanation.

Use OPENROWSET

http://msdn.microsoft.com/en-us/library/ms190312.aspx

Try @attachments parameter of xp_sendmail.

http://msdn.microsoft.com/en-us/library/aa260697(SQL.80).aspx

MJ

Try:

BEGIN TRANSACTION

SELECT* FROM tblMyTable with (TABLOCKX)

MJ

Its 2005 and I am using admin account for the same.

Mj

I think auto shrink option applies to all files rather than just data files.

MJ

Same error with sp_readerrorlog too...

Paul,

His question was regarding difference in service pack level as he got confused with OS pack level and SQL SP Level.

MJ

Post the output of sp_helpuser 'username' after u run it under the db in question.

Yep you can.

You can't rename sql server instance name, server name can be renamed.

For example, you can change a computer named MB1 that hosts an instance of SQL Server named Instance1 to...

These are Certificate-based SQL Server Logins

Server principals with names enclosed by double hash marks (##) are for internal system use only. The following principals are created from certificates when...

Note:

Stop the SQL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service uses the connection, thereby blocking...