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 )
sedostalAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Scott PletcherConnect With a Mentor Senior 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
 
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
 
sedostalAuthor Commented:
This pointed us in the right direction.. Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.