A Copy Database wizard was run and the optional Master objects were copied as well. They weren't meant to be included in the copy and now there are 5 Stored Procedures in the destination Master showing they were created at the time the copy was done. I don't remember if those stored procedures were already on the destination server before the copy. Is it possible that the copied Master SP objects could have overwritten any existing SP with the same name in the Master? I know that MSDB objects aren't copied if they already exist, but is it the same for Master objects? Please help.

I have done that once or twice and never noticed anything being overwritten, but I don't know for sure.

Are we talking about the Transfer Databases Task in 2000? AFAIK that didn't
allow you to take over system databases i.e. Master.
Or are welking about the Transfer objects task which does allow you to move
things from master?

The latter will not show you objects defined as being SYSTEM.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jared F" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks for your help. I am talking about the Copy Database Wizard on SQL Server 2000, where it lets you move or copy supporting shared objects in Master and MSDB, etc along with the database you're copying. I saw in the documentation that the MSDB objects wouldn't be copied if they already existed on the destination server, but it didn't say that about the Master objects (It didn't say they would either). What I am worried about is whether or not the user defined stored procedures which were copied from the old server to the new server could have overwritten stored procedures of the same name (that were possibly changed since being on the new server). Thanks again.

In message <575DE80C-5186-4F73-9DE4-6858CFA510BD (AT) microsoft (DOT) com>, Fiona
<anonymous (AT) discussions (DOT) microsoft.com> writes
Not familiar with the Wizard, but I if it is a concern/problem why not
try one of the numerous database compare tools available, e.g.

Compare and synchronize the structure of SQL Server databases
(http://www.red-gate.com/SQL_Compare.htm)


Apex SQL Tools: SQL tools for Database comparison and synchronization
(http://www.apexsql.com/index_sqldiff.htm)


There are loads more, but they are two companies I can remember the Url
for to have a quick look. I like Red-Gate myself, but haven't really
done a proper market comparison.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org