DEP019 System table or view is deprecated

System table or view is deprecated

This SQL Server 2000 system table is included as a view for backward compatibility.

We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views. This feature will be removed in a future version of Microsoft SQL Server.

Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Compatibility Views (Transact-SQL) (MSDN)

 

Mapping System Tables to System Views (Transact-SQL)

sysusers sys.database_principals Catalog view

 

作者:Chuck Lu    GitHub
posted @   ChuckLu  阅读(38)  评论(0)  编辑  收藏  举报
相关博文：
· How to Stopping System-Versioning on a System-Versioned Temporal Table in SQL Server 2016?
· Top 3 Tips You Need to Know to Write Faster SQL Views
· SQL Server教程 - T-SQL-视图（VIEW）
· sqlserver 创建表时，为何会出现不支持该后端版本设计数据库关系图或表的提示？
· 数据库 android 数据库软件
阅读排行：
· 全程不用写代码，我用AI程序员写了一个飞机大战
· DeepSeek 开源周回顾「GitHub 热点速览」
· MongoDB 8.0这个新功能碉堡了，比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· 白话解读 Dapr 1.15：你的「微服务管家」又秀新绝活了
历史上的今天：
2020-07-18 Life Cycle Stages of IIS 7.0
2019-07-18 widget jquery 理解
2017-07-18 sqlcmd
2017-07-18 无法往SQL Server Management Studio拖脚本
2016-07-18 Task<TResult>的使用
2014-07-18 C#创建继承的窗体
2014-07-18 git的软件安装
点击右上角即可分享
微信分享提示