Friday, June 6, 2008
dtproperties Table in SQL Server 2000
gets updated automatically.
Basically this is a system table but when we run the below query we will get the name of
dtproperties table in the result set, indicating that this is user table.Microsoft has
confirmed that this is a bug in the Microsoft SQL Server.
Select * from sysobjects where xtype='u'
Labels: SQL Information