a mature elevation - undoubtedly:-D

I'm still stuck on "higher steaks" - would that be rare, medium or well done?! :hehe:

ps: Sorry - couldn't resist. I'd say go with your gut instinct. Typically there's only...

changed the syntax to include a ";" (semicolon) before the statements - apparently that's how they'll compile...still getting an error when the trigger is fired through the app...regardless, I can...

Thank you Lowell and Steve - for your response.

I set a trace using "TSQL_Grouped" template and ran the app ad infinitum; kept tweaking all sprocs that did not specify schema...

stupid not to have thought of the tags..will repost in a minute.

It is windows based...and no...just one connection string at the beginning stored in an ini file...

point noted about profiler...will...