RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

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