Check with the SMTP servers administrator. I noticed that your FROM address is not the same domain name as the SMTP server that you show. As SPAM prevention...

Goodbye to 2014 and hello to 2015. Happiness to all in the new year. That is what I mean by Happy New Year.

Steve is so right. You...

Happy Holidays!

no, wait ...

Holy Happy Days!

umm ....

I was right the first time. Either way, actually.

I have had the DROP fail because their were existing connections. The SINGLE USER thing seems to work the best in most cases.

One other caution is to watch your...

I am such a big fan of ISO 8601 that I write all my dates as YYYYMMDD. The folks at my bank never blinked twice. I have also...

Scott you are correct. One point though there will be no clustered index at all. They will all be non-clustered.

From http://msdn.microsoft.com/en-us/library/ms189049.aspx we find this:

A foreign key constraint does...

Hey PiMané I would recommend that you take your SW vendor out into the woods for a good spanking for making a clustered index on UNIQUEIDENTIFIER column. You are...

Hey .Netter, I'm not sure that we helped you out here and I don't want to leave it like that.

What did you mean by better? Without that we seemed...

So do I still have to deal with the virtual needles falling on the virtual floor? That drives me virtually nuts!

"Hi. I'm \\Administration\CafeThree and I'll be your virtual...

The DDL triggers are a great idea. It covers things that are changed after the triggers are in place. What is missed is the base line that was...

LOL! When you make it go faster it is heavier. While SQL is my...

Be careful poking fun at Jeff. I would not like to get hit with an RBAR! :w00t:

Lowell have a look at XXCOPY[/url].

Kathy there are some free or low cost things that will help.

First is SQLCMD. I use that all the time to run scripts with...

Chris we used a similar approach in Scout. Not only for system wide configurations but that gets extended down to specific users through roles.

Steve this will pull memories from...

Rather than a global temp table what about a table type variable?