Bruce W Cassidy (4/28/2009)

---

[font="Verdana"]This morning I had an idea. After I had had a bit of a sit down to recover from that novel feeling, and to reassure myself...

The normal forms have a purpose. There are times when it's better to violate them.

Like every rule that isn't a natural law, there are times when it's best to...

You're looking at the right columns. They've been Int all along. It's a pain.

SQL 2005 isn't really built for that. The features worked so poorly in SQL 2000 (too many security holes, etc.), so they pretty much replaced it in 2005. ...

There are lots of methods of handling duplicates in SQL. To help you design the best one for your situation, we would need table definitions ("create table..." scripts) and...

This version will...

First, raw XML disappears when you post it in the forums. You need to use the code tags around it, with the XML type, or to attach it as...

You can generally add a step to the code that attempts to connect to the database and, if it fails, it goes to a catch block and does whatever you...

Is it appending the backup to an existing backup file? That's pretty usual, and can definitely cause this to happen.

In that case, you might want to take a look at OpenRowset. With that, you can query Excel directly, as if the spreadsheet were a table. That might...

Try something like this. See if it gets you what you need with the desired efficiency:

IF OBJECT_ID(N'tempdb..#Threads') IS NOT NULL

DROP TABLE #Threads ;

IF OBJECT_ID(N'tempdb..#Posts')...

Depending on the number of rows you actually...

Try something like this:

update D1

set bool2 = D2.bool2

from #detail D1

inner join #detail D2

on D1.sdetailid = D2.detailid

and D1.bool2 != D2.bool2;

You're welcome. Glad we could help.

Database Mail is asynchronous. E-mail system failure won't hang up the trigger.

You can also set failover e-mail servers in the options, if you have access to such, and if...