Nagabhushanam,

That works great in SQL Server 2005 but has no chance of working in SQL Server 2000.  Good to see how this works, though.

Take a look at the COLUMNS_UPDATED feature of a trigger and make your Audit table look something like this...

AuditID ModDate ModBy TableName ColumnName NewValue (OldValue)

... I put OldValue in...

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?