No sir.

That is why you see the string concatenation of the month day and year.

It would be easier but alas it wasn't built that way.

Excellent info gentlemen! I've been researching this issue myself.

Have any of you experienced difficulties with the DTC or other cluster services becoming unavailable?

Thanks a lot

Thanks for the info Grant.

Dale

Thanks Grant for the reply. Yes the profiler can definately impact production. But I'm using the default trace in Profiler. It captures both the RPC statement begin and statement completed...

If it were me in this situation, you have a mandatory down time, production is stopped until you can get this database up to speed on the secondary server.

1)...

Chris Harshman (12/4/2008)

...reminds me of the old joke: How many Microsoft programmers does it take to change a lightbulb? 0, they declare...

I have seen where DBAs would right click the DTS Package (SQL 2000) and schedule a job.  If you schedule a package to run that way, the SQL Job it...