I added a couple more features as well, to extend to object level permissions as well and check for orphaned logins. It's based of the main table your script...

This script is a lifesaver. It keeps our Loss Prevention folks happy when they need to audit any servers.

GilaMonster (11/11/2008)

Depends what kind of maintenance window you have nightly. Last big DB I worked on took 4 hours to backup fully. Nightly maintenance window was 2 hours. Hence we...

We hardly use differential backups here anymore. Less headaches is to have a full backup daily and transaction log backups every 30-60 minutes.

For example, if you use diff backups,...

Thanks...and as a point of reference, the original query of 14000 separate updates, with 'go' placed every 1000 updates, took about eleven hours. With any luck, this will take...

Here's the pertinent code within the trigger:

UPDATE a

SET a.DateChanged = getdate(),

FROM dbo.tblCatalogData a -- tblCatalogData was my targetTable

...

Archive tables with little or no frequent access afterwards are probably the only time I'd avoid an index. Should I have to retrieve data from it in some manner,...

Here's a useful method. This assumes that your backup is copied remotely on a regular basis, which I STRONGLY recommend (we use Netbackup but you can use many different...

Another option, and this involves being a bit more proactive, is if you have any archive type tables in your database, let them be located on a secondary filegroup on...

Once in awhile, I enter online contests of the more legitimate type, but as I have no idea what even they would do with my email, I keep just one...

How about get rid of NT AUTHORITY\SYSTEM on all production servers? That, along with picking the right form of authentication (mixed vs. SQL only) can help avoid aggravation in...

Sorry about the late reply, was swamped at work. 🙂

One way to do it for each database is either the undocumented sp_msforeachdb feature or roll it into a loop. You...

Even more importantly, I recommend for sanity purposes in the future, you come up with a formal process whether or not to use varchar/nvarchar in tables. This keeps things...

If this is anything like my experience up here in Canada, it should be pretty straightforward.

We get a monthly CD from CanadaPost with a basic flat ASCII file that has...

What do I want for my birthday? World peace...or failing that, developers in our company agreeing to stick with one collation.

Okay, seriously, a new laptop. If I'm going...