Why a DTS?  Do you have data that you need to access on a different database system?

Where did you look for to find those DBA jobs?  I know that there are at least a few posted just in here each months.  Then I guess that monster.com...

Look up change management articles on this site.  There's no automated way to do this as far as I know.

It can be done, but the whole code must be dynamic (from the declare cursor to the deallocate).

Also without looking at the code I'm sure there must be a better...

From an existing proc?

From a trigger?

Please provide the required output from the sample data you provided (I'm not trying to annoy you, I just want to get it right the first...

So what do we need to do with this?

We need more information on this one.

Can you provide the tables definition, some sample data and the required output.  Also explaining wether you need to do this from a proc...

I've also had troubles with speed with ssms.  And I've heard quite a few others complain about that one.  However 30-40 secs to edit something, that's way worse than what...

Can you post the code?

"Surprisingly enough, I got quite a bit of advice from Chris S here on the site. He pinged me about changing the forums to not pop a new window on...

The only time I saw something like this is when I coded something in QA (with some static values instead of parameters).  Then forgetting to change them once going to...

Happy to help.  Come back anytime you have another question.

I think that the instead of triggers let you access those datatypes, but I have never done that so I could use a confirmation on this one.

No.

But keep in mind that ANY statement (even print '' or set @MyVar = 4) made after the query will either reset it to 0 or to the new number of...

Yup, but I have very strict requests.  Never hurt to ask however.