How to start SQL Server in different modes?
Submitted by: MuhammadSingle User Mode (-m): sqlcmd –m –d master –S PAXT3DEVSQL11 –c –U sa –P *******
DAC (-A): sqlcmd –A –d master –S PAXT3DEVSQL11 –c –U sa –P *******
Emergency: ALTER DATABASE test_db SET EMERGENCY
Submitted by: Muhammad
DAC (-A): sqlcmd –A –d master –S PAXT3DEVSQL11 –c –U sa –P *******
Emergency: ALTER DATABASE test_db SET EMERGENCY
Submitted by: Muhammad
Read Online SQL Administrator Job Interview Questions And Answers
Top SQL Administrator Questions
| ☺ | Tell me why would you use SQL Agent? |
| ☺ | Please explain why would you call Update Statistics? |
| ☺ | How to start SQL Server in different modes? |
| ☺ | Tell me what is SQL Server VSS Writer? |
| ☺ | Do you know what is SQL Server service and its importance? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
