How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answers were Sorted based on User's Feedback
Answer / m.sivakumar
The SQLSERVR.EXE is located in binn directory of Sql server.
-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / hanumathkumar
-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.
Is This Answer Correct ? | 2 Yes | 2 No |
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?
Difference between report and query parameter.
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
can you instantiate a com object by using t-sql? : Sql server database administration
What is key attribute?
What are the differences between substr and charindex in sql server.
write the query for taking database restore in sql?
What are the steps you should follow to start sql server in single-user mode?
How to loop through result set objects using odbc_fetch_row()?
What are the differences between user defined functions and stored procedures?
how many instance use in sql server 2005
What happens if ntwdblib.dll is missing on your machine?