Delete user table dtproperties SQL Server

Question

Delete user table dtproperties SQL Server

Navigation

#1 by (2 votes)

1

Is there any consequence of deleting the user table dtproperties of SQL Server ?, I am filtering the permissions of Role Public and verifying that this Role does not have DML and DDL permissions different from the Default ones that point to tables of user since otherwise all users would have those permissions on that table and would have a security failure.

sql-server sql-server-2008

asked by Cristian Zauco 13.12.2017 в 23:51

source

1 answer

I want to put Google Maps on Android and get the error: "could not find depency com.google.android" problem when saving records with fetch - error Undefined index

score 2 · Accepted Answer

Table dtproperties , along with several objects dt_* are associated with the creation of DER type diagrams from the SQL Enterprise at least until the version of SQL 2000. If we are not interested in maintaining these diagrams, we can do a DROP of the table without more consequence than the loss of these diagrams.