VERY nicely done... VERY easy to read and the comments are just right... What do the contents of the tblRefTimeZone look like and where do folks get that info...

Actually, you'll need quite a few other scripts if there are indexes, foreign keys, and triggers.  That's why I use EM to take care of it... it "automagically" does all...

Nope... couldn't do that because the first underscore will interfere with finding the second underscore.

I can't tell if you want "High/Low" returned as a literal or a boolean... this will do the boolean thing... let us know what you really need.

DECLARE @MyCase INT

... do...

Yep... use OSQL to run the query from a CMD prompt (or using xp_CmdShell w/ trusted connection) with a redirect (the -o option) to a text file.

See "Books Online" for...

Mark,

Remi and I got a bit carried away on a sidebar... are you all set or do you need additional help?

Roger that... thanks.

Alright... I've been looking for a while, now... how the heck do you submit a QOD on this forum?

p.s.  Forgot to mention that the 812006 in the file names can change...   I just assumed that the "Watch" prefix could change, as...

Outstanding, Ray... that was the next thing I was going to ask... who changed what?  You beat me to it.  And, thank you very much for the feedback... you'd be...

First, you must realize that SQL is NOT SQL... most books on SQL I've seen rely on supposed advanced techniques using ANSI SQL.  Others are based more on what Oracle...

Was it ever able to see D?

Vladimir,

The best way to do this is to collect all the data from the user first even if it's for 4 or 5 levels, as you claim.  Then, do a...

Might as well bite the bullet while you're small...

Lock down the production database.  Remove SA, DBO, and DDL ADMIN privs from all developers and users.  Insist on code reviews and unit/itegration...

I think you may want to look into the reason for the backoffice DB starting up twice... that should not happen...