PDA

View Full Version : EnterPriseManager


champion
دوشنبه 14 اسفند 1385, 22:03 عصر
سلام دوستان
راهی هست که بشه تشخیص داد enterPriseManager هنوز start نشده و خودمان از طریق این برنامه اونو Start کنیم ؟
nasr
دوشنبه 14 اسفند 1385, 22:08 عصر
می تونی با دستور net start اون را استارت کنی
با یه فایل bat
nasr
دوشنبه 14 اسفند 1385, 22:23 عصر
How to stop the default instance of SQL Server (Command Prompt)
To stop the default instance of SQL Server

From a command prompt, enter:
net stop mssqlserver



Note Stopping a default instance of Microsoft® SQL Server™ using SQL Server Enterprise Manager or the net stop mssqlserver command causes SQL Server to perform a checkpoint in all databases. Then a SHUTDOWN WITH NOWAIT is done to flush all committed data from the data cache and to stop the server immediately. Stopping a default instance of SQL Server from the command prompt works only if you are running Microsoft Windows NT® 4.0 or Windows® 2000.