You could make the first step of the DTS package delete the records in question (and connect it to the existing steps in the package with an On Success), then...

You callin me a novice?

This is a very different approach that the way I usually think about these things. I like thought expanding...

You lost me at hello

I'm following you a little bit now that you explained it. I'm just trying to imagine when I could...

I can't really see arguing with someone who was/is on the ANSI comitee - I was just asking about one of those interesting things about English and uncovered some more...

You could also look into Indexed Views. Depending on the indexes you put on the view, you could end up with something close.

If you don't add the /3GB switch to boot.ini, SQLServer will grab 2GB and the OS will grab 2. Since you went from 2GB to 4Gb, you should now be...

Check out the scripts section too. Someone published a sctipt that would do a DBCC Showcontig on each table and then loop through them performing maintenance based on a fragmentation...

Not exactly an answer, but there is a series of articles that talks about the ins and outs of transactions and xact_abort.

http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart1.asp

http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart2.asp

http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart3.asp

You can do this via DTS.

I had a package (on Server B) that initiated a backup on a database to a backup device located on a network share. You...

I bet that the email is your culprit. Log into the server (either directly or via term services) as the account that SQL Server Agent runs under (the one the...

Yikes, didn't mean to start a huge discussion. Just to add more fuel to the fire, here's a guideline I found online:

The Chicago Manual of Style (sec. 14.15, p. 464)...

Rick, best solution yet!

Oh, BTW. tell the pronouncing acronym thing to the SAP people. They get uptight when you pronounce SAP like what you call the stuff that seeps out of trees. Unless...

I had heard both about SQL vs. SEQUEL (IBM's original name, IIRC), Joe, and I thought the pronouncing it Ess-Que_El was more correct.  I tend to say Ess-Que_El myself. I thought that...

Who's complaining? 🙂

I was just wondering because I see and hear both. I kinda like the way English is 'malleable.' i took French in High School and I always thought...