thanks, probably the best working code dealing with the subject. I replaced the datetime with time(0), just easier on my eyes:

CAST(STUFF(STUFF(REPLACE(STR(run_time, 6), ' ', '0'), 3, 0, ':'), 6, 0,...

Thank you for posting this, very elegant solution. Too many DBA's are not aware of problems with sysdepends and consequently don't know how to get reliable information about their system.

just a note about something that may be confusing. the article talkes about linking an ADT to a column - this is not a correct concept. ADT just like "standard"...

great article,

It's a wonderful Idea to do something about the general level of expertise in the DBA world. It's a bit of a problem, because it is one of the...

This is true, I did not think that this solution was portrayed as "the only one". just that the performance concern is pretty big, and osql option is just as...

while it may seem like a nice idea to run a multi instance task right from your Query Analyzer, I wouldn't do it. First of all performance is bound to...

almost forgot, if already using osql, why involve DTS in the picture? wouldn' it be just as easy to run your query using OSQL and use the output of that...

One thing I don't get is how the transaction log backup devices are reinialized. It just seems that log backups would get appended w/o an end. am I missing something?

normally I'd agree with you, but fact is that this log is growing, and you can guess what is going on there, but if you really want to know take...

Hi Mike,

see what SQLBill wrote about this (above). It seems to me that the best thing (and that's what I wound up doing)...

Wayne, did you find a solution ? If so, please post it. I seem to be having the same issue.

Yes to regional settings

no to nulls

I am not sure how collation would be relevant since we are talking about a datetime field, but yes, both servers are SQL 2000 and both DBs are of the...

Thanks,

I feel a bit not so smart, but even though I looked through it million times, I missed it. sp_text was defined as nvarchar. Now that I changed it to...

Thank you so much,

eithere set @var='' or set concut_null_yields_null off produces desired results without coalesce. Which makes me wonder what it was doing there in the first place...

Anyhow, thank again....