|
Programmatically start and stop SQL Server main service
|
Total Hit (3257) |
Using the SQL-DMO object model you can programmatically start, stop, pause, and continue the main SQL Server service. In the following code snippet the server is "MyServer", and "sa" / "mypwd" is the user name and password of a user that is allowed to start/stop the service:
«Code LangId=6»
' N
....Read More |
Rating
|
|
|
How to script SQL tables using SQL DMO
|
Total Hit (2295) |
«B»Introduction«/B»
SQL-DMO encapsulates SQL Server components and presents them as attributes of the component piece to you as properties of an object instance. You would have to alter the properties of the instance or use object methods to automate SQL Server administration. This article takes
....Read More |
Rating
|
|
|
How to Schedule a Job Programatically with VB
|
Total Hit (884) |
First off, set a reference to Microsoft SQL-DMO in your VB project. You will need to have SQL Server 7 installed on your box for this. I haven't tried this under SQL 2000 or SQL 6.5
|
Rating
|
|
|
|