Alternately you can use the scripts in the URL below to script your logins

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

Try the following

1. Right click on SQL Server Agent --> Properties --> Alert System --> Select the Database Mail as mail system and the mail profile (do this even if...

like mentioned above db_state_option is the placeholder and ::= indicates to replace the placeholder with a valid option.

Has there been any thought about excluding snapshot databases as well from the process. I tried this with a snapshot database on a server and it stopped processing.

That's a very generic error

- trying pinging the database server from the machine you're getting the error, even try connecting from a different client machine

- look at the sql logs...

Are you seeing any issues?

You have upgraded to SP4 (8.00.2039).

Run the following query to confirm. The SP2 is the OS version.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

RTM - 2000.80.194.0

SP1 - 2000.80.384.0

SP2 -...

have you rebooted the box? it's been a while since i did this, but sp4 does require a reboot.

When using DB mirroring in the past, I've set the transaction log to backup every hour during business hours and every 3 hours during off-hours. This helped keep the log...

did you log in to the server console to see if some process was causing the server not to reboot? See if anyone else is RDP'd in to the server.

I didn't realize that it was already obsolete up until now. I have tested this for a very large DW and have seen significant disk space savings.

George any update on this? I will be evaluating different options shortly and would like to know if you got to the bottom of this.

Third party or not would also depend on

1. Whether you're looking for one solution for all your databases or not.

2. budgetary constraints, if any.

3. In-house expertise for managing...

SELECT * FROM sys.server_principals

WHERE type IN ('U', 'G')

Did you look on the Microsoft web-site?

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