run a profiler trace and collect the login success event.

sp_changeobjectowner

my take is that is is a matter of opinion. I think it's much easier to get certified if you have the experience. That doesn't necessarily mean you can't get...

That is it - couldn't remember what that setting was for the life of me - Thanks

use either osql or sqlcmd, depending on your version of SQL (2000 uses osql, 2005 is sqlcmd)

you can use that to run sp_startjob

so your command may look like this:

osql -E...

there is no link between SA and your service account, although most people I know add the service account to the SA role

Check out DDL triggers in BOL and you should be able to get what you need.

that is usually set on the client side.

specifically, what is the error you get?

Thanks all for your suggestions on how to handle this mess. The designer has ran off to a far away location for obvious reasons. Thanks again!

Good suggestion!

yes, the second example is exactly what we are looking for, although it doesn't necessarily need to be every other row. as long as the ID is not duplicated...

Unfortunately, I don't have an answer as to why this is the way it is. It's already in production and they got a dupe in one of the tables, hence...

That did the trick, Thanks!

I encourage everyone to try a few things here.

I am a huge fan of trying things several ways and simply testing to see what one runs the fastest for...

We use one account for production, one for QA, one for dev and one for test. since the servers are the only ones that use the account, they shouldn't get...