Just giving this a bump, hard to believe that the community is not using this type of software. Would love to hear from y'all.

Wish it meant something more, I'd love to see more intensity than just whatever pride generates. To see the best of the best go at it like it was...

One reason I've set our named instances to specific ports is our firewall rules. We want control over over which machines connect to our databases, even if it means...

Just found this thread, fun stuff. Giants fan here, NL West is crazy insane. I'm not holding my breath, though.

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

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.