Okay....

Start here:

http://www.sqlservercentral.com/articles/Administering/debuggingmsdtcissues/1257/

http://www.sqlservercentral.com/Forums/Topic450909-146-1.aspx

😎

Not that familiar with the behind the scenes processing. I just seem to remember seeing something similiar to this before and this was the suggestion given. Can't hurt...

To get you started, you'll want to use a ForEach container and the FileSystem task. Exactly how you would use them, I don't know off the top of my...

Looking at BOL, it looks like you use just like a table.

I would still load the data into a temp table before doing the join.

😎

Take a read of BOL. I think I have seen this before, and you may need to use OPENROWSET.

😎

No. He asking if you can add the table you want to join into the stored proc and join it to the other tables there.

😎

You need to populate a temp table with the results from the stored proc and then join to the temp table. Unfortunately SQL Server does not let you treat...

I'd need a little more specifics. The table DDL, smaple data (in the form of insert statements that can be cut, pasted, and executed to populate the table), and...

I'll agree, you have a process that is working, you don't need to change it unless your requirements change.

One of the things I sometimes needed to do was restore a...

That sounds like a good script for the script library.

😎

I was manually zipping backup files using PKZip. and it did a great job. Problem was: 1) it was manual, and 2) it was time intensive.

Using HyperBac cut backup...

First, Steve probably hasn't seen this thread yet, as he may be off at a conference. I know that when he learns about an issue such as this,...

Personally, I'd leave it in the existing table. If you move it to a second table, then you have to create an outer join to the secondary table to...

smunson (6/25/2008)

majorbloodnock (6/25/2008)

OK. That's the way it came across, but I'm happy to apologise if that wasn't your intention and...

Then I will make the assumption that you'll be the first to volunteer to vet future QotD and willing to stick with it through thick and thin. I would...