Check cns
-
I have run sp_depends against a table where we suspect that there are errors/dodgy programming but got the above result. What does it mean?
Madame Artois
-
What message??
-
Sorry. This was the result of running sp_depends 'table name'.
dbo.table name_CK1 check cns dbo.table name_CK2 check cns dbo.V_table name view Madame Artois
-
It mwans that those objects are linked to that tables. The first two are check constraints and the last one is a view of course.
You must also be aware that sp_depends is not very reliable because it is not guarenteed that all the objects will be listed in there.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply