Migrating MSDB stored procedures

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Migrating MSDB stored procedures

Author

Topic

SQLBuddy123
Starting Member

26 Posts

Posted - 2009-06-15 : 11:35:40

Hi,

I am doing migration from SQL Server 2000 to 2005.

Could anyone please tell me whether I should migrate the MSDB stored procedures that are outside the folder “System Stored Procedures “like r_iRTblClassDefs, r_iRTblClassExtension, r_iRTblDBMProps etc..,

Actually,these stored procedures are present in every SQL Server 2000 instance we have. I am not sure whether these are user created or system created.

Thank You,

Yours
SQLBuddy

swekik
Posting Yak Master

126 Posts

Posted - 2009-06-15 : 13:38:56

These are System Sprocs.If you are migrating the server from 2000 to 2005 ,No need to migrate these.

SQLBuddy123
Starting Member

26 Posts

Posted - 2009-06-15 : 16:10:16

Hi Swekik,

Thank you very much for your reply. I really appreciate your guidance.

Yours
SQLBuddy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources