Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2301
  • Last Modified:

Discover dependencies failed on SQL Server 2008

I am using the Generate Scripts option to generate scripts (tried with and without data) on my database.

I get this error:
Discover dependencies failed.  (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement. (Microsoft.SqlServer.Smo)
Invalid object name '#tempdep'. (.Net SqlClient Data Provider)

It directs me to a deadend page:

I'm going to do more research on whether this is occuring with all my databases, or just the one, but thought I'd get this out here for now.

Starr Duskk
Starr Duskk
1 Solution
#tempdep is the table that SQL Server uses while working on dependencies.  Look here to see the code that they (apparently) use: you might want to try it out, as you might get to where you want to get to!




Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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