September 22, 2008 at 5:58 am
Hi
i have migrated a sql server 2000 DB to sql 2005. And some system stored procedures are mixed with self created SP.
Bit on other migrated DB the SP are apart.
What could be the issue?
September 22, 2008 at 8:47 am
With the information you've provided I believe it's possible to say that some of the stored procedures are stored in the msdb database and some are stored in the filesystem.
Did you use the wizard from 2005 to import them?
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
September 22, 2008 at 8:50 am
No, i used a backup / restore
and i found a lot of dt_xxxx sp.
September 22, 2008 at 8:53 am
You could try to use the import wizard for DTS packages from SQL Server 2005. Your results may vary.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
September 22, 2008 at 9:04 am
i will try with the wizzard.
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply