SHUTDOWN will switch off an instance of SQL Server without performing checkpoints in all databases.This command will end all user processes and finally closes SQL Server. When SQL Server restarts, it rollbacks all uncompleted transactions.
Syntax:
SHUTDOWN [ WITH NOWAIT ]
You must be a user having either sysadmin or serveradmin fixed server roles to issue SHUTDOWN command.
I hold Bachelors degree in Computer Science along with MCSD,MCTS and MVP for the year 2009. Areas of Interest: C#, WPF, WF, silverlight, ASP.NET, Oracle and SQL Server.
Join the conversation! Your thoughts help the community grow.