We did try that, then Profiler complained that there were events missing. The traces replay from the files just fine.

I always install the client tools on the server - you never know when you aren't going to have network access, be working in the server room, etc.

On an...

Unfortunately, the SQL Server 2000 machine is accross a slow WAN connection, so I need to perform the trace locally there and then copy the file back here and replay...

I want to connect to a SQL Server 2000 instance and run a trace toa file. I then want to copy that file to a SQL Server 2005 instance...

Francis, Aikido and Kendo both have a spiritual side, at least at the places I've seen. Spiritual that is - not religious.

You can certainly have Zen in martial arts....

One thing a former instructor told me that I'll always remember - "When you get your black belt (edit) it means you are ready to start learning."

All of the color...

Get him a savings bond (or some other type of investment, but a savings bond is nice because you have the actual bond) and hold it till he turns 18....

Always good to see Morihei Ueshiba.

I haven't run into too many techs who do martial arts, but I haven't been very active in martial arts since I moved to...

I didn't think that it was all that difficult, but my strategy on these types of MS exams is to read the intro, then skip ahead and read the questions....

For SQL Programming/Analytical questions Some of the standard ones are:

1) How to Find top 3 maximum values in a column (ANS using TOP clause with ASC)

Do you mean DESC? Wouldn't...

Yep, I've tried to do that (duplicate file structure), but with clustered servers and multiple drive letters it can really be a headache.

I've tried using network shares to get...

Does SSIS have the same issues as DTS when running remotely (can't get access to files on the server, etc)? That one has always necessitated local logins for me -...

Maybe I'm not the norm in this respect, but I've never worked in a company where I had to ask for a raise. Everywhere I have worked had (at least)...

Why are we, as a profession, always looking for another profession or avocation to compare ourselves to?

The easy answer (i guess) is because the IT industry is relatively new....

Microsoft has a ton of information right here:

http://www.microsoft.com/sql/technologies/highavailability/default.mspx