There's no best practice here. If the truncate works, and it doesn't impact your system, then that is simpler to me. However this might reset things or cause issues, so...

Do you have an error?

I would suggest you grab a template from ConnectionStrings.com, as noted above, and use that.

Whoops, the article is here: http://www.computerworld.com/s/article/9160118/Tap_the_wisdom_of_employees_and_boost_the_bottom_line_

GSquared, I like the idea of the parameter. That would be very handy to know during the creation of modification of some DDL statement. That could then be exposed later...

Good luck, Barry. Hope it all goes well

Put out a general note, we are auditing access, etc. If your login doesn't work, let us know. It's an easy way to find out who is using systems, and...

I've usually only documented databases at a point in time, when there is this need to a large scale change to the system, or a lot of new developers start...

Congrats, Paul and Jason.

Those QODs and posts add up, though be careful of burnout. I've seen this happen before a few times. Do what you enjoy, and when you get...

I don't know that a table driven approach is being dismissed, and I think that's the best idea. One I'd recommend over Paul's. Another system db is possible, and if...

I don't think there's a way to be sure of the last date, but you can disable logins and then see if someone complains.

I have a simple one, but if anyone wants to suggest one, feel free.

That was funny, especially as I was working on an Apr 1 QOD with DBCC Timewarp (suggested by Alvin) at the time.

I just saw that thread posted by Paul. With Kim out of town, he's in a cranky mood. Never a good day to argue with, but I think this week...

You have a good point, but I think you're coding around a very unlikely possibility. There is literally thousands of scripts, including system scripts in SQL Server that contain

IN ('master',...

Ha! I'm far from 100% on the QOD. I'd like to say I'm testing wrong answers, which I do at times, but rarely. I tend to just give it the...