July 15, 2005 at 8:25 am
Hi,
I have written an application that acts as a reporting/monitoring tool across about 25 servers. It works very well and I don't have a question about how to programme with DMO.
My question is where are the objects? Does that make sense?
For example dmo returns a code to signify the status of the agent service - but where does it get this code from. It can't be querying a table (I don't think) so where are the objects that it queries.
Sorry to be showing such a lack of understanding.
Hope you can help ...
July 15, 2005 at 11:26 am
The query could be the Windows system service, it doesn't have to be inside SQL. The DOM wrapper is around low level code, not necessarily TSQL/TDS stream code. you can run profiler to see if it is querying something in SQL Server, but some of them do not.
July 18, 2005 at 6:49 pm
SQL-DMO is just a wrapper. I've run SQL Profiler against my own SQL-DMO code as well as when I perform task via Enterprise Manager and found that it's just querying system tables directly or executing some of the sp_MS% stored procedures. I suggest you fire up Profiler and trace your application to determine what it's doing behind the scenes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply