I can't replicate the behavior. I tried using trusted connections & sql connections and unchecking the "remember password" on the connection window. Once I'm connected to a server, every time...

Correct me if I'm wrong, but doesn't the black box trace only keep a rolling set of data? You'll need to set up an actual trace. Make it to file...

I have to agree. The inner join seems like the most logical approach.

Using the same temp tables above:

UPDATE #TableA

SET Col3 = b.ColC ,

Col4 = b.ColD,

Col5 = b.ColE

FROM #TableA a

INNER JOIN...

I'm not sure I have the precise answer, but I was just reading how certain errors can't be trapped at the moment of execution, but can be at a level...

Nothing there, you may want to repost.

However, assuming the XML is well formed, you have multiple options for importing it.

Definitely go for the varchar(max). The only down sides are disk space, but that's easily monitored.

I wasn't going to comment on the Tuning Advisor, but since the gate is now open... I haven't had good experiences with the Advisor either. I haven't had it ruin...

Oh, and, I'd offer to help her work on her performance issues in order to clean up her system enough so that you can connect to it.

Steve's correct. Further, some degree of processing will occur on both of the servers, no matter what. Bare minimum, depending on what kind of server you're linking to and how...

Still not there.

One other suggestion, I'd use SSIS over DTS especially since you're trying to move data to 2005.

I'm largely piling on at this point, but what the heck...

Yes, seperate the databases by customer and seperate them by module as well. If possible isolate by instance or use...

I was thinking the same thing, but I did some searching Integer8 and it's actually a 64 bit value. I'm not convinced you can put it into a BigInt, but...

You are posting your questions to the 2005 TSQL forum. Any answers are likely to contain syntax that won't work in 2000. That's...

The first two messages are lower level messages that are not a part of the TSQL statement, but are occurring at a lower level within the system. The CATCH statement...