sysdepends | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sysdepends

my sysdepends it not updated. any way to update this?
Did you update the statistics? Brett :cool:
WHat is the service pack level on SQL? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
auto create & update stats are on. sql 2K std ed.
sp 3
Any errors related to sysdepends and how can you determine its not updated. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Do you mean that sysdepends no longer reflects what you know the relationships to be? If so, then this is normal behaviour. The only way to ensure that sysdepends is always up to date is to create objects in the ‘correct’ order, i.e. create dependant objects before creating the object which depends on them Cheers
Twan
]]>