Interested to Buy Any Domain ? << Click Here >> for more details...
How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 11365 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / abc
sqlserver.exe is located in the binn dir of sql server ie
program files\m sql server\mssql\binn and we can get help
related to it on dos prompt
to start server at single user mode or admin role we have
to specify -m ahead of the command
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is indexed view? How to create it?
what purpose does the model database serve? : Sql server database administration
How to divide query output into multiple groups with the group by clause in ms sql server?
Explain the ways to controlling cursor behavior?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is the function of inner join?
Tell me what are the essential components of sql server service broker?
What is cdc in sql server?
What is autocommit mode in sql server?
What is use of dbcc commands?
What methods do you follow to protect from sql injection attack?
What is sparse columns of sql server 2008?
Which sql server table is used to hold the stored procedure scripts?
How will you go about resolving deadlocks?
What is TDS(Tabular Data Stream) Gateway?
