Discover dependencies failed on SQL Server 2008

Posted on 2012-08-28
Last Modified: 2012-09-07
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.

Question by:BobCSD
    1 Comment
    LVL 16

    Accepted 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!



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Title # Comments Views Activity
    SQL Compatiblity Mode 4 36
    SQL HELP 2 65
    How to enforce inte 8 27
    SQL Dynamic Insert 18 40
    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now