Hilary - thanks.  I think sp_addscriptexec would do it.  I've actually now created the SPs I want in the subscriber database and configured them not to be overwritten during the...

Not if you protect the DTS package with a password.

You need to ensure that the correct trust relationship is set up between the two domains.  After that, grant the account that starts SQL Server the necessary permissions on the...

Assuming you are using SQL Server 2000 (SQL 7.0 doesn't support multiple collations on the same server), use rebuildm to rebuild the master database, specifying the new default collation.  Beware,...

Every time SQL server is started, tempdb is recreated from the model database.  You need to modify the properties of model so that the changes you make will survive a...