1
Vote

Application crashes while creating view script

description

Application crashes and returns the following error when application is traversing the view tree after creating table, user define fuction, roles, users:

"Unhandled Exception: Microsoft.SqlServer.Management.Smo.FailedOperationException: Attempt to retreive data for object failed for Server 'ServerName'. ---> Mircosoft.SqlServer.Management.Smo.SmoException: Invalid Urn filter on server level: filter must be empty, or server attribute must be equal with the true server name.
at Microsfot.SqlServer.Management.Smo.Server.CheckValidUrnServerLevel(XPathExpressionBlock xb)
at Microsfot.SqlServer.Management.Smo.Server.GetSmoObjectRec(Urn urn)
at Microsfot.SqlServer.Management.Smo.Server.GetSmoObjectRec(Urn urn)
at Microsfot.SqlServer.Management.Smo.Server.GetSmoObjectRec(Urn urn)
at Microsfot.SqlServer.Management.Smo.Server.GetSmoObject(Urn urn)
--- End of inner exception stack trace ---
at Microsfot.SqlServer.Management.Smo.Server.GetSmoObject(Urn urn)
at.ExportSQLScript.Program.ScriptDependencyTreeNode(DependencyTreeNode dependencyTreeNode)
at.ExportSQLScript.Program.ScriptDependencyTreeNode(DependencyTreeNode dependencyTreeNode)
at ExportSQLScript.Program.Run()
at ExportSQLScript.Program.Main()"

file attachments

comments