To drop all tables from a sql server database with one command is very simple.
You can use the system stored procedure "sp_MSforeachtable".
Paste in query editor the snippet:
exec sp_MSforeachtable "DROP TABLE ? PRINT '? dropped' "
That's all folks!
You can start, stop, pause and resume Sql Server Services as all other services.
To manage the default database istance open command prompt and type:
- NET START MSSQLSERVER - Starts SQL Server
- NET STOP MSSQLSERVER - Stops SQL Server
- NET PAUSE MSSQLSERVER - Pauses SQL Server
- NET CONTINUE MSSQLSERVER - Resumes SQL Server