In message <575DE80C-5186-4F73-9DE4-6858CFA510BD@microsoft.com>, Fiona
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view] >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.
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