A different sql server database can be accessed like this :

use master

go

Select * from msdb.dbo.sysObjects.

Would this solve the current problem of database access?

Sorry for asking so many questions but...

No clue.  I've been a developper all my career but then again, I never really looked for a DBA job.  If you are strictly asking for a dev job that...

That's pretty easy (unless I don't have all the requirements for the problem).

All you need is the have this data in a derived table select :

Id1, id2, RowsNum

then you...

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.