Solved

C++ API implementation of SQL SMO

Posted on 2007-12-06
2
1,057 Views
Last Modified: 2011-04-14
Is there a C++ implementation available for exposing objects in the Microsoft SQL Server Management Objects (SMO) dynamic link library SQLSMO.DLL?  As far as I can tell, SQLDMO cannot be used to manage instances of SQL Server 2005 and has been superceded by SQLSMO.  Thank you.
0
Comment
Question by:gssdev
2 Comments
 
LVL 86

Accepted Solution

by:
jkr earned 250 total points
ID: 20422250
It seems that there is nothing out there so far, see http://www.ftponline.com/vsm/2004_en/magazine/features/rjennings/page3.aspx ("Get Ready for SQL Server 2005"): "You program SMO and DMO operations with VS 2005 by adding .NET references to assemblies. COM wrappers support unmanaged VB, C++, and VBScript SMO programming."
0
 

Author Comment

by:gssdev
ID: 20449438
After some tweaks and turning on disabled options in SQL Server 2005 it so happens that SQLDMO does still function sufficiently to do what I need it to do.  Your response on SMO is what I expected though, I just don't have the time to build COM+ wrappers for those objects at this time.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…

808 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