Click here to Skip to main content
15,884,176 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi6-Nov-03 7:39
professionalJeff Varszegi6-Nov-03 7:39 
GeneralRe: SQL Statement question. Pin
theJazzyBrain6-Nov-03 21:48
theJazzyBrain6-Nov-03 21:48 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi7-Nov-03 2:43
professionalJeff Varszegi7-Nov-03 2:43 
GeneralRe: SQL Statement question. Pin
theJazzyBrain7-Nov-03 4:04
theJazzyBrain7-Nov-03 4:04 
Generaluser acces spermissions Pin
ranjjj6-Nov-03 0:10
ranjjj6-Nov-03 0:10 
GeneralRe: user acces spermissions Pin
perlmunger6-Nov-03 10:57
perlmunger6-Nov-03 10:57 
GeneralRe: user acces spermissions Pin
ranjjj6-Nov-03 17:36
ranjjj6-Nov-03 17:36 
GeneralRe: user acces spermissions Pin
perlmunger7-Nov-03 5:38
perlmunger7-Nov-03 5:38 
Here is a basic definition of SQLDMO that I found here: http://www.expresscomputeronline.com/20030616/techspace1.shtml

"DMO is a set of objects that represents the SQL Server infrastructure. This is a very rich and complex object model. It is not intended to provide data handling, which is best done by traditional SQL commands.

DMO is designed for administration of SQL Server using a component object model approach. In fact, using DMO, you can do things that are impossible with Enterprise Manager. Moreover, it is often much simpler to write a DMO based code rather than trying to find equivalent Transact SQL syntax for achieving certain administrative tasks."

Things I've used it for include:
- Listing available SQL Servers
- Listing available databases in a given server
- Programmatically "walking" a set of database tables for generating database objects based on those table

(just to name a few). It is a very useful component. I found a link here http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q287/7/37.ASP&NoWebContent=1 that demonstrates listing available SQL servers using C++. I'm sure there are many more examples out there, so you should just do a google search for the term "C++ SQLDMO" or something like that. There tend to be more examples out there written in VB or C#, however, the same component can be referenced from C++.

Let me know if you need any further clarification.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
GeneralProblem in using OleDbDataReader Pin
sivaramakrishna5-Nov-03 22:14
sivaramakrishna5-Nov-03 22:14 
GeneralRe: Problem in using OleDbDataReader Pin
Mike Dimmick6-Nov-03 2:32
Mike Dimmick6-Nov-03 2:32 
GeneralRe: Problem in using OleDbDataReader Pin
sivaramakrishna7-Nov-03 19:06
sivaramakrishna7-Nov-03 19:06 
Generaldbo Pin
Hugo Hallman5-Nov-03 12:19
Hugo Hallman5-Nov-03 12:19 
GeneralSQL! Pin
Silly Boy5-Nov-03 6:18
Silly Boy5-Nov-03 6:18 
GeneralRe: SQL! Pin
Jeff Varszegi5-Nov-03 7:34
professionalJeff Varszegi5-Nov-03 7:34 
GeneralRe: SQL! Pin
andyharman5-Nov-03 11:49
professionalandyharman5-Nov-03 11:49 
GeneralEncoding problem using ADO Stream Pin
Firas Rashid4-Nov-03 2:59
Firas Rashid4-Nov-03 2:59 
GeneralAlternative SQL Queries based on Table Data Pin
Jo Fredrickson3-Nov-03 21:58
Jo Fredrickson3-Nov-03 21:58 
GeneralRe: Alternative SQL Queries based on Table Data Pin
andyharman5-Nov-03 11:35
professionalandyharman5-Nov-03 11:35 
GeneralRe: Alternative SQL Queries based on Table Data Pin
Jo Fredrickson5-Nov-03 14:59
Jo Fredrickson5-Nov-03 14:59 
GeneralMSADO 2.5 Pin
Kant3-Nov-03 15:46
Kant3-Nov-03 15:46 
GeneralRe: MSADO 2.5 Pin
Mike Dimmick5-Nov-03 1:51
Mike Dimmick5-Nov-03 1:51 
GeneralRe: MSADO 2.5 Pin
Kant5-Nov-03 5:01
Kant5-Nov-03 5:01 
GeneralFULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 12:53
devvvy3-Nov-03 12:53 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
Jeff Varszegi3-Nov-03 14:28
professionalJeff Varszegi3-Nov-03 14:28 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 14:30
devvvy3-Nov-03 14:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.