I wouldn't be ashamed, I'd be proud.:-D

I don't how to or if you can use xpsmtp for operators/alerts, but I don't think there is.

You do have to install Outlook to...

Another one do the noisy 50 chiming in.

Until about 2 years ago I was only vaguely aware that PASS existed and that was because I saw reference to the Summit...

Not to sound sarcastic, but they show because there are 1905 dates in the table. They are probably typos, but you'll have to determine that.

Mitch,

Thanks for your input. I'm just reporting what I saw. It shouldn't be case-sensitive. I need to get some different VM's up to test against. I...

Wow! That's a big compliment for just responding to a question on the forum for one of my articles.

Glad...

Mitch,

Sorry to have taken so long to reply, but I just noticed my notification email. Let me first say that I can understand your frustration. It can be...

In the code you have posted you are missing a comma (,) after COUNT(NHSNo) AS [patientvol].

If you are doing the password update using stored procedures then I would put all that logic in the stored procedure. If you must do it in a trigger,...

I've never had the issue although one person I mentioned it to said that they have had it happen once and their Exchange Admin cleared the queue and that cleared...

Hmmm, I could take that a couple of different ways.:-P

Andy Leonard[/url] has a set series of 5 articles on Test Driven Database Development that starts here[/url].

Bob,

I really wish you'd quit beating me to answers tonight!:-D

There is a lot of debate on the issue. Here's a link to a post by the SQLCAT team, http://sqlcat.com/technicalnotes/archive/2008/09/25/the-many-benefits-of-money-data-type.aspx and here's one to another thread here on SSC,...

The developer's head right! 😉

I have created a Connect Item and all you need to do is vote it up, verify it, and comment on it as desired.