Discover dependencies failed

Question

Discover dependencies failed

akramer.mail

SSC Veteran

Points: 277
More actions
October 4, 2010 at 2:48 pm

#224706

Hello All,
I'm working my way through "Beginning SQL Server 2008 Express"... clear sailing to page 85 when ...
Script Database as-> create to-> New Query Editor Window
Yields the following error message:
Discover dependencies failed
Database is not supported in dependency discovery
Any direction would be appreciated
Thanx
Al

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Shazme Ten Centuries Points: 1292 More actions · Answer 1

Hi ,

check your tables/SPR's by right clicking and going to view dependencies. It looks like your databse dependenices causing the problem .

you might try to "changing the Generate Script for Dependent Objects to false."

Or create a new test database and script to see if its giving the same error.

There is an issue about Agent Jobs as per link below but not aware of anything else.

http://connect.microsoft.com/SQLServer/feedback/details/371669/unable-to-script-job-in-sql-server-management-studio-of-sql-server-2005-or-sql-server-2008

Thanks

ImI

akramer.mail SSC Veteran Points: 277 More actions · Answer 2

Hi ImL,

Thanx for the reply

"check your tables/SPR's by right clicking and going to view dependencies"

I clicked around in the Object Explorer but couldn't find the poroperties... Where should I be looking?

Al

akramer.mail SSC Veteran Points: 277 More actions · Answer 3

Here's the text of the error message:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Discover dependencies failed. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Discover+dependencies+Scripter&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

Database is not supported in dependency discovery. Only objects of the following types are supported: UserDefinedFunction, View, Table, StoredProcedure, Default, Rule, Trigger, UserDefinedAggregate, Synonym, UserDefinedDataType, XmlSchemaCollection, UserDefinedType, UserDefinedTableType, PartitionScheme, PartitionFunction, DdlTrigger, PlanGuide, SqlAssembly, UnresolvedEntity. (Microsoft.SqlServer.SqlEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

BUTTONS:

OK

------------------------------