开发者

Residual SQL Server 2000 Objects When Restoring DB to SQL Server 2008

开发者 https://www.devze.com 2023-03-10 05:45 出处:网络
I\'ve performed a RESTORE DATABASE command to restore an SQL Server 2000开发者_运维百科 database on SQL Server 2008. The script ran and showed several messages showing the DB being upgraded. What I\'v

I've performed a RESTORE DATABASE command to restore an SQL Server 2000开发者_运维百科 database on SQL Server 2008. The script ran and showed several messages showing the DB being upgraded. What I've noticed is that (seemingly) legacy database objects from SQL Server 2000 have been migrated to the SQL 2008 DB.

For example, there are stored procedures whose name starts with dbo.dt_ in both the Stored Procedure and System Stored Procedure folders when viewing the DB in Management Studio. There was also the table dbo.dtproperties listed under tables.

Is it safe to drop these objects? These objects aren't in a DB created in SQL 2008 itself, so I'm thinking yes. But I'd like to make sure :)


Those objects exist for database diagrams. If you don't have any database diagrams in your database that you care about, then it is fine to delete those objects.

0

精彩评论

暂无评论...
验证码 换一张
取 消