dbTalk Databases Forums  

wmi access to sql server

comp.database.ms-sqlserver comp.database.ms-sqlserver


Discuss wmi access to sql server in the comp.database.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bob & Martha Vera
 
Posts: n/a

Default wmi access to sql server - 02-24-2004 , 05:09 PM






Hello,

Forgive a newbie's question ...

Can I access SQL Server and the databases and tables within using windows
script?

If so, could someone point me in the right direction?

Regards,
Bob



Reply With Quote
  #2  
Old   
Ozone
 
Posts: n/a

Default Re: wmi access to sql server - 02-24-2004 , 06:51 PM






You need to look at ADO. This is how you access a DB from a Script.

http://msdn.microsoft.com/library/de...e/list/ado.asp

Ozone
"Bob & Martha Vera" <gmbvera (AT) comcast (DOT) net> wrote

Quote:
Hello,

Forgive a newbie's question ...

Can I access SQL Server and the databases and tables within using windows
script?

If so, could someone point me in the right direction?

Regards,
Bob





Reply With Quote
  #3  
Old   
Simon Hayes
 
Posts: n/a

Default Re: wmi access to sql server - 02-25-2004 , 02:14 AM



"Bob & Martha Vera" <gmbvera (AT) comcast (DOT) net> wrote

Quote:
Hello,

Forgive a newbie's question ...

Can I access SQL Server and the databases and tables within using windows
script?

If so, could someone point me in the right direction?

Regards,
Bob
There is a WMI provider for MSSQL on the CD - it's not installed by
default. Alternatively, you can use SQLDMO for management tasks, or
ADO for data manipulation, from any COM-enabled language. See Books
Online for full documentation.

Simon


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.