Learn how to a build a cloud-first strategyRegister Now

x
  • 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:
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1750.9+((dac_inplace_upgrade).101209-1051+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Discover+dependencies+Scripter

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.

thanks!
0
Starr Duskk
Asked:
Starr Duskk
1 Solution
 
DcpKingCommented:
#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!

http://www.sql-server-performance.com/forum/threads/tables-used-by-the-store-procedures.1956/

hth

Mike
0

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