Sorry, my fault. I failed to mention this will be just in the test/qa environment and not prod.

The Devops was mentioned by the developers but from what little I read,...

The commands below worked per database...

GRANT VIEW DEFINITION TO [<USERNAME>]

I was misinformed, they didn't want to see the agent jobs, they want to see what accounts exist in the SQL...

Do you have a "dummys" version instructions on how you setup the startup procedure?

I've been out of SQL mgmt for a while and getting back into it.

I found this:

• This reply was modified 2 years, 5 months ago by  Warren Peace.

Thanks, I will give this a try this week.

Windows Server Failover Cluster and SQL Failover Cluster Instance.

Thanks!!

I wholeheartedly agree!!!!!

My post already states the....

"Local hosts file has the principle and mirrors IP and NetBIOS name and fqdn.".

Hmmm...

Will this work????

CREATE TRIGGER [connection_trigger]

ON ALL SERVER WITH EXECUTE AS '...'

FOR LOGON

AS

BEGIN

IF EXISTS = (SELECT ORIGINAL_LOGIN_NAME FROM sys.dm_exec_sessions WHERE database_id = 11 AND ORIGINAL_LOGIN_NAME = 'mydomain\prefix-MV-purpose$')

ROLLBACK;

END;

GO

ENABLE...

yup, that was it. Upon creation, <default> meant the account I was logged in as.

Thanks

Check to make sure the account that SQL runs as has full NTFS permissions to that folder.

I know you are just putting a "Test" DB in there but the fact...

PaulB-TheOneAndOnly (10/27/2011)

---

Well... in a fifty serves environment is reasonable to have a well established division of responsibilities.

Weekend pages are part of our job or as one of my bosses used...

Yes, over 5000 employees and over 50 SQL Servers (not counting the ones I already manage.) and some clusters in an "Undisclosable Government...

What was the reason for the SQL Server Admin to be locked out? Seems rather counter productive. If you're going to be in charge of all that "Sensitive Data" why...

OK, figured it out.

Here's the KB: http://support.microsoft.com/kb/2494447

Apparently when you do an inplace upgrade it still references the object "/images/blank.gif ".

After beating this around for a while, a co-worker...