Error when attempting to watch buildings in Management Studio
I am having problem with sql supervisor after install SQL 2005 SP3,
Can any kind of lose any kind of light on this set.
TITLE: Microsoft SQL Server Management Studio
Can disappoint asked for dialog.
Can disappoint asked for dialog. (SqlMgmt)
Method not located: 'Microsoft.SqlServer.Management.Smo.Edition Microsoft.SqlServer.Management.Smo.Information.get _ EngineEdition () '. (SqlManagerUI)
This could have something that can settle the concern: http://download.microsoft.com/download/5/7/1/5718A94A-3931-457B-8567-AA0995E34870/ReleaseNotesSQL2005SP3.htm
There can be some absent SQL Server SMO setting up documents. To address this, simply follow this procedure:
- Look for an installation which functions great
- Copy all documents from
C:\Program Files\Microsoft SQL Server\90\SDK\Assembliesfolder and also paste it in
C:\Program Files\Microsoft SQL Server\90\SDK\Assembliesof the equipment with the damaged installation.
- Do not overwrite any kind of documents. Simply replicate the missing out on documents
If it was a data sources is buildings you were attempting to consider, examine the proprietor of the database you are attempting to consider. It could be orphaned - you can make use of
EXEC sp_changedbowner 'sa'
and also see if that aids (does not need to be sa - whatever the ideal account is)