I think the only way to get the text-name for the month would be to do a CASE statement on MONTH(DATEADD(m, -1, GETDATE())) to return the correct string for each...

Oh - I forgot to answer your other question. Check to see if mixed mode logins are enabled on the instance, and if so, confirm that the username/password combination...

The username value you are putting in after the -E is being ignored and you are logging in as a windows user. Connect using -E BLAHBLAHBLAH and run SELECT...

right or wrong, THAT was hilarious.

Chad

Well trick question or not, I learned some new stuff about cursors! Some day I'm going to have to go through BOL just to see all the stuff I...

Thanks Steve! Help me understand your concern about a hot spot. Are you thinking about centralizing the DDL auditing for a single server, or aggregating multiple servers together?...

tjaybelt, this is way cool, thanks so much for being willing to share.

Do you know offhand the differences between using this method and replacing the trace files with...

Marios, I'm very interested in hearing how reducing parallelism helped reduce or eliminate the issue on your server. I debated on whether or not to start a new post...

Hey GSquared - thanks for having such a good attitude about the comments on your QOTD. I get burned by misreading a QOTD every once in awhile -the one...

You could combine both of your queries into one using a CASE. Make it even more powerful using Ken's REVERSE and then manually inspect the oddball ones to make...

I would think it is doing the count before the cast. Since it's just counting the number of non-null values, it doesn't really need to know what kind of...

I'm guessing just a little, but is the dll behind the extended stored procedure missing or moved perhaps? I found that it was connected to xpstar.dll in \MSSQL\Binn....

Hope this helps,

Chad

Use a datetime and have the default value be GETDATE(). A timestamp is a binary value that changes every time the row is updated - useful if you want...

Mary,

Can you post some of the ideas you have tried?

Thanks,

Chad

You only get a success stub off each task, so drag one of the success ones to your task, then double click it and change it to be a failure....