Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SMO compatibility error Expand / Collapse
Author
Message
Posted Tuesday, September 4, 2012 5:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 4, 2012 5:39 PM
Points: 1, Visits: 4
Is anyone aware of any forward compatibility bug in the SMO library?
We are having an issue with a .NET client using SMO to check for create database permission.
It seems to have trouble reading the 2008 R2 library when communicating with SQL 2012.
Post #1354262
Posted Monday, January 5, 2015 8:27 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, February 25, 2015 8:59 AM
Points: 93, Visits: 204
When using SMO for SQL Server you need to remember that going backwards is supported but going forward will not always work. In your case this is especially true. Get the updated SMO libraries for the version of SQL Server you are running and things will work correctly.

Ben Miller
Microsoft Certified Master: SQL Server, SQL MVP
@DBAduck - http://www.dbaduck.com
Post #1648326
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse