I think what you might be looking for is a view. Although not a true nickname/synonym it should work. I would create a view that references your ADMIN...

What kind of errors are you getting? How close is your SP to the one I send?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website...

Yes you can do this. I'd read up on "External tools", in BOL.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

I think this has something to do with VSS. You may also notice there are some dt_xxxx store procedures.

Gregory Larsen, DBA

If you looking for SQL Server Examples...

Yes, you can put a password on SA by using EM. Go to the Security Tab, click on Logins, find SA and right click, then enter a super secret...

Would it be practical to disable the trigger. Run the 20000 updates and deletes, then run a new process (might have to build) that does the trigger logic based...

Forgot to ADD OSQL could be executed via xp_cmdshell, via a SQL Agent job.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Looks like you already have a solution. OSQL could have also been used to execute the query, and write the output to a file. OSQL could be...

No I have not checked into the performance issues. I might be interesting to see if there are any issues here.

If I get the script I will make...

Might want to read Brian Kelleys "Start to Finish Guide to SQL Server Performance Monitoring" of a start. It's an Ebook.

Gregory Larsen, DBA

If you looking for SQL Server Examples...

Possible you could do the following. Not very slick, but might work.

1) Prior to making a SP Change, create a new database call it version_X_Y_Z, where X,Y and Z is...

Not that I know of. Possible the REPLACE function will work for you. Something like this:

declare @str varchar(50)

set @str = '2541,2542,5362,36585,36884'

select replace(@str,',',char(13))

Gregory Larsen, DBA

If you looking for SQL...

This article might give some ideas:

http://www.sqlservercentral.com/columnists/glarsen/orphan_user.asp

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Think I would use DATEPART:

print datepart(ss,GETDATE())

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

schema_ver is just a number that changes each time you make a table change. You will need to keep track of what was before you make a change in order...