Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 651
  • Last Modified:

What is SYSSQLEXPDEPENDS?

I'm unable to find anything regarding SYSSQLEXPDEPENDS.
When investigating a problem with a piece of code,  we are getting the following error

(SQR 5528) ODBC SQL dbexec: SQLExecute error 208 in cursor 29:
   [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'SYSSQLEXPDEPENDS'.

We are currently running MSSQL 2008. Does anyone out there know what
SYSSQLEXPDEPENDS is ?   If its in MSSQL 2008 and what its used for??

Its used in the following code
WITH OBJECTDEPENDS(ENTITYNAME, REF_ENTITYNAME,REFERENCED_ID, REFERENCING_ID,LEVEL)
   AS (
   SELECT ENTITYNAME = CASE REFERENCING_CLASS WHEN 1 THEN OBJECT_NAME(REFERENCING_ID) END  ,
   REFERENCED_ENTITY_NAME ,REFERENCED_ID ,REFERENCING_ID ,0 AS LEVEL  
   FROM
   SYSSQLEXPDEPENDS AS sed WHERE REFERENCED_ENTITY_NAME = $InvViews_SqlTableName
   UNION ALL
   SELECT ENTITYNAME = CASE sed.REFERENCING_CLASS WHEN 1 THEN OBJECT_NAME(sed.REFERENCING_ID) END ,
   sed.REFERENCED_ENTITY_NAME ,sed.REFERENCED_ID ,sed.REFERENCING_ID ,LEVEL + 1
   FROM OBJECTDEPENDS AS o JOIN SYSSQLEXPDEPENDS AS sed
   ON sed.REFERENCED_ID = o.REFERENCING_ID )
0
sedostal
Asked:
sedostal
  • 2
1 Solution
 
smiliefaceCommented:
I suspect this may have been the dependency tracking in an previous version of SQL.

Has this been upgraded from SQL 2000?
0
 
sedostalAuthor Commented:
The code may have been written for MSSQL 2000 capabilities. Any way to find out if that in fact is something in 2000?
0
 
Scott PletcherSenior DBACommented:
I don't recognize that as from SQL 2000.  

SQL 2000 had a "dbo.sysdepends" view (which was highly unreliable, btw).  That view is available as sys.sysdepends in SQL 2005.

The current view (SQL 2008+ at least) is sys.sql_expression_dependencies, or sys.sql_dependencies (SQL 2005).
0
 
sedostalAuthor Commented:
This pointed us in the right direction.. Thank you
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now