Jezemine,

you are 100% spot on! Peer built the new cluster with an older version.

Thanks,

Eddie has exactly what you need in the prior post. if you are a truly 24x7 shop and using transaction logs, cutting over in a few minutes during lunch will...

The instance has eight databases and only backs up the first four and the jobs ends with no errors. it just does half of the databases in the cursor.

SET NOCOUNT...

🙂 I kept googling and found a guy who had done the exact same thing and the following corrected the problem:

--- Reports the current compatibility level of 'MyDBName'

EXEC sp_dbcmptlevel...

Jo,

The answer is Yes. what is the tsql command to do the same?

This corrected the issue thanks. This is what happens when you become a useless mgr.

thanks a lot!

Les

2006-03-29 20:08:53.38 server    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

 May  3 2005 23:18:38

 Copyright (c) 1988-2003 Microsoft Corporation

 Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2006-03-29...

Yelena,

It is a SQL Server. I made sure the port was active and listening and I opened the Client Network Utility and found it setup on 1433 and changed it...

Allen,

thanks for the help. I was able to configure a trace that audits logins and logouts. It is exactly what I needed although not as easy as the sybase way.

Thanks...