You'll need to be granted

VIEW SERVER STATE

and

VIEW DATABASE STATE

to be able to use the mentioned DMO in Glens script.

We grant these privileges to our devs (dev and qa instances)...

Have a look at the wonderful scripts Glen provided for us .

SQL Server 2005 Diagnostic Information Queries by Glenn Berry

http://sqlserverperformance.wordpress.com/2012/06/12/sql-server-2005-diagnostic-information-queries-june-2012/

Both queries look the same to me ...

Except for the cast clauses used with the second one !

Are you sure your @varriable-content isn't longer than 10 characters ?

where SetupDetailsId...

Apparently you didn't want to do a one by one approach, just generate your stuff !

Select 'ALTER LOGIN ['+ name + '] DISABLE ; '

from sys.server_principals

/* exclude disabled accounts, sysadmins...

Just disable the logins and the engine won't let anybody in !

It works as well for SQLUsers as for windows logins and groups.

ALTER LOGIN [AnySQLUser] DISABLE ;

ALTER LOGIN [yourdomain\your_windowsgroup_EXEPT_SQL_ADMINS] DISABLE...

We always use Gert Drapers' solution mentioned at : http://www.sqlservercentral.com/Forums/FindPost368228.aspx

If this is a production box, I recommend setting "auto close on" property to false.

This way sqlserver will bring the db online when the...

You've seen the message:

it says ...check the eventlog...

I...

The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released

support.microsoft.com/kb/2679368

Thank you for adding these great references to...

gbargsley (7/30/2012)

---

Great article. It always amazes me how many people don't know about this feature. I still find servers in our infrastructure that do not have it enabled.

I...

Mea culpa, mea culpa, mea maxima culpa ➡

Dear, Jeff, forgive me because I have sinned.

I hope you don't kick me out of the anti RBAR brotherhood.

Actually...

that's why - although not mandatory - it is best to keep disk-layout equal at db instances involved in db mirroring.

If you need to add a data file in a...

Here's an ( oldfashioned ) alternative so you can compare performance depending of the % of your set that needs to be updated.

Run it over a big set of data...

the described scenario is other people activated an IPS system.

There is only little you can do if they don't inform if such thing would cause issues for your db-server or...