Can you use the NOCHECK option on the constraint?

I. Disabling and re-enabling a constraint

The following example disables a constraint that limits the salaries accepted in the data. NOCHECK CONSTRAINT is...

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

BoL has great info...on that page check out 'Viewing Windows permissions for SQL Server Services'.

There's a MS white paper also, google 'microsoft best practices sql server', you'll find a link...

Google is an awesome tool:

http://msdn.microsoft.com/en-us/library/ms143269(SQL.90).aspx

Thanks again. I had done the same Googling considering the ramifications of the TRUSTWORTHY setting and saw similar results.

Interesting idea with a monitoring job. I'll look at my...

I've finally finished my version of the stored procedure, and indeed, as you stated, Lowell, I need to change the TRUSTWORTHY property of the 'master' database to ON for this...

Try single user mode then:

http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

Do have the administrator password to the Windows server administrator account that the database instance resides on? If so, and if the former admin did not remove the BUILTIN/administrators...

I've just recently set up Oracle Enterprise Manager 10.2.0.5 GRID control and the SQL Server plugin needed to monitor the SQL Server instance, here's some of my experience:

If you're using...

"This is not 'Nam, this is bowling....there are rules." - Walter Sobchak

Sacramento, California. Yes, it's sunny here and we all like to surf. Oh yeah, and everyone smokes pot.

It appears that a re-install of the Oracle client software solved this problem.

Sorry this was posted in the wrong forum.

Thanks for the feedback from everyone.

Grant, how do you receive forum alerts from MSDN? I've tried setting up alerts thru my Windows Live account, but they don't seem to...

Error seems fairly poignant...you mentioned it's across a different domain, I'm wondering if you're running into the AD replication cycle or something.

Hard to tell what the problem...

Any errors in the event log (SQL and Windows events) on the receiving server? Wonder if you have something running there that bogs down the server, or drops connections...

I've used SQL Server DTS successfully, so I'm sure the SSIS packages are just as nice. I've also used the SSMA for migrating Access, fairly clean interface also.