将数据库恢复到 SQL Server 2008 时残留的 SQL Server 2000 对象
我执行了 RESTORE DATABASE 命令来在 SQL Server 2008 上还原 SQL Server 2000 数据库。脚本运行并显示多条消息，表明数据库正在升级。我注意到 SQL Server 2000 中的（看似）遗留数据库对象已迁移到 SQL 2008 DB。
例如，在 Management Studio 中查看数据库时，存储过程和系统存储过程文件夹中都有名称以 dbo.dt_ 开头的存储过程。表格下还列出了dbo.dtproperties 表。
掉落这些物体安全吗？这些对象不在 SQL 2008 本身创建的数据库中，所以我想是的。但我想确定一下:)
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 :)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这些对象用于数据库图表。如果您的数据库中没有任何您关心的数据库图表，那么删除这些对象就可以了。
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.