?
Solved

C++ API implementation of SQL SMO

Posted on 2007-12-06
2
Medium Priority
?
1,077 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 86

Accepted Solution

by:
jkr earned 750 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

764 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