Replication Monitor

configuration Replication Alert

replication warning : Transsactional replication latency [threshold latency]

After this Select-->SQL Server Performance Condition Alert(under Type)--Then-->Select MSSQL$YUKON1:Replication Logreader Under Object

then Select-->Logreader:Delivery Latency(Under Counter)-->Then ur instance and alert...

Drop the user named 'abc\btsdadmin' from this database first and then add it again by using sp_changedbowner command.

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...