I have resolved these issues with the following ms article:

http://support.microsoft.com/kb/914157

Thanks, Kevin

Just wondering if anyone has any advice on this issue.

No, please do not confused the isssue here or assume it is something as simple as running the SQL Server Maintenance Jobs during the Exchange/DC Servers Maintenance window. Please read...

Once the Exchange Server or DC come back online (after maintenance), my SQL Server Jobs continue to run successfully. The jobs just do not send out the emails associated with...

Thank You.

Now, how will I schedule this task? May I put this osql command in a batch file and schedule it using the Windows Scheduled Tasks? Is there a Windows...

Thank You. However, I still would like to know is there any way to monitor whether SQL Server is up or down by using Windows O/S commands? (Like with Unix...

Just curious, when you say to 'disable a log backup', do you mean to stop the SQL Maintenance Plan from creating the log backup?

Kevin

Sarabpreet,

Thanks for your response. I have two questions; what do you mean when you say:

1. Disable the log backup on prod.

I am taking a nightly full database backup and log...

Thanks. Here is another issue we are having. Say we have a DB with owner Ted which we have forgot the password. Is there anyway to change the DBO owner...

Thanks John and to all who responded. The xp_msver extended sp provides a wealth of information.

Kevin

With each SQL Server Instance, do you set the memory during the install or after the install? To set the memory after the install, I believe you right click the...

Is there a SQL Server 2005 32-bit version that I could load onto the 32 bit processor?

Thanks to all of you for your assistance, Kevin

Also, if I am able to install 3 Instances (sql 2000, sql 2005 and sql express 2005) on the same machine, how should I divide up the memory (3GB) between...

This is the results I get with 'select @@version' on our machine:

Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c)...

No 'select @@version' does not explicitly display 32 or 64-bit. I have tried the following sql commands and neither supply what I am looking for.

--Version Number

select @@version

--Service Pack

select serverproperty('ProductLevel')

--Version Number

select...