Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips


3 of 3     Previous     Next
Programmatically start and stop SQL Server main service
by Francesco Balena
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: ' ...
Start SQLServer Dynamically with
VB and SQL-DMO Objects
by KulBhushan Sharma
Create a new standard exe project and add reference of sqldmo.rll. This file can be found in \Binn\Resources\1033\sqldmo.rll under SqlServer70 directory.
Using SQLMAINT.EXE Command-Prompt Utility
by Jai Bardhan
You can use SQLMAINT.EXE command-prompt utility to perform routine database maintenance activities. It can be used to run DBCC checks, to dump a database and its transaction log, to update ...
3 of 3     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date