99% of the scripts we use are in house or customized from sites like SQLServerCentral.com

That being said, there are a couple third party tools that are worth their weight in...

Steve Jones - Editor (11/19/2008)

---

Sorry for the late note.

Seeing the paper result, but not holding it is interesting. And it's a good compromise, perhaps the best we'll ever get.

I read...

Jeff Moden (11/19/2008)

---

Gaby A. (11/19/2008)

---

Thanks everybody, given me food for thought. Unfortunately this DB was set up before I joined my company but but at least in the future,...

Thanks everybody, given me food for thought. Unfortunately this DB was set up before I joined my company but but at least in the future, if I get any...

Hmmm...we just had a national election here in Canada, and we just used pencil and paper. Granted, ours is a parliamentary system where we did not elect a President...

nelsonj (11/13/2008)

---

The password generator does a nice job, but while testing the code in QA, I noted that the proc does seem to return an "abundant" number of 'repeats' in...

RML51 (11/14/2008)

---

No knock on the script, but I question the value of truly random passwords.

I think I have a pretty good memory. I have my credit card number memorized...

Jeff Moden (11/13/2008)

---

Pretty nice, Gaby... your article and some of the comments above gave me a couple of ideas for an article with just a pot-wad of tricks in it......

After you create the script, run this command from within master:

exec sys.sp_MS_marksystemobject 'sp_YOUR_SCRIPT_HERE'

which allows you to run it from any database.

This is also a good book that the DBA's in my department refer to:

http://www.amazon.com/Microsoft-SQL-Server-2005-Unleashed/dp/0672328240/ref=sr_11_1?ie=UTF8&qid=1226931286&sr=11-1

Try this one as well: http://www.sqlservercentral.com/scripts/Administration/63841/

It's one I recently used to audit a server for our Internal Auditors.

I found this as a possible solution, using shrinkfile, from http://blog.sqlauthority.com/2007/04/01/sql-server-tempdb-is-full-move-tempdb-from-one-drive-to-another-drive/

[font="Courier New"]use tempdb

dbcc shrinkfile(templog, 0)

backup log tempdb with Truncate_Only

dbcc shrinkfile(templog, 0)

[/font]

Avoid the hassle of shrinkdatabase. But maybe have the...

MANU (11/12/2008)

---

Please add and islogin=1 to your where clause as on my installation its displaying rows for userid which is not there under sysusers and not under syslogins too(its weird...

Okay...the proper/full workaround I came up with was:

create table #TOrphans

(

DBName varchar(128) collate SQL_Latin1_General_CP1_CI_AS,

UserName sysname collate SQL_Latin1_General_CP1_CI_AS

)

exec sp_msforeachdb

'use ?;

insert into #TOrphans(DBName, UserName)

select db_name() collate SQL_Latin1_General_CP1_CI_AS, Name collate SQL_Latin1_General_CP1_CI_AS from dbo.sysusers

where name...

I agree with Brandie, sometimes the most useful scripts are surprisingly simple and elegent. Will make my reporting to the Loss Prevention folks more manageable.