Better than the Analyst I had who wanted to open up a .ldf in notepad to do a search for a string value! That was one for sqldumbass.com let...

Returns more info than what is asked for and the scope is the current db just as the other approach.

Something like this will place everything into a single result set. Just drop the temp table #Results when done.

CREATE TABLE #Results (SERVER VARCHAR(100), DatabaseName VARCHAR(100), NAME VARCHAR(100), filename VARCHAR(200))

EXEC...

Well, since it needs to work for 2005 as well as 2000 you can't use the DMVs or DMFs. This will do the trick however:

EXEC sp_MSForEachDB

'SELECT CONVERT(char(100), SERVERPROPERTY(''Servername''))...

It is not only a member of the SysAdmin server role in the SQL instance, but is also assigned to the AD group that has local administrator rights on the...

Dominic, you could script out the changes you want to make and place the scripts in a step within a SQL Agent job and schedule it to run at the...

I used to use sp_update_user_logins all the time, but with 80+ servers and almost 1,000 databases that I support without aid of a Jr. DBA I had to abandon that...

What I tend to do is estimate out 3 years of growth and size the databases I support initially to be that 3-year final size. Why 3 years? ...

I will agree with Steve that auto close will work, and sledgehammers are fun to play with... just so long as these are not mission-critical databases. I work...

Steve, isn't that kind of like hitting a nail with a sledgehammer? Or more like hitting a cute, adorable puppy with one? Even if you are not sure...

Gary, are you interested in looking at activity that has already occurred or in setting something up to monitor activity over a period of time starting now? What sort...

I recently ran across this myself. We had multiple linked servers on different SQL servers hitting Oracle and doing so quite well for years. Then it was brought...