--COMMAND PROMPT DAN SINGLE MOD CALISTIRILIR SQL To start SQL Server in single user mode: Start a command session (start > Run > "cmd" [Return]). To ensure that SQL Server is not running type: net stop MSSQLServer This may say that this will also stop another service (typically SQLSERVERAGENT), in which case allow it to continue. It will also indicate if the service is already stopped. To start SQL Server in single user mode type: sqlservr -m If this is not recognised then cd to 'C:\Program Files\Microsoft SQL Server\MSSQL\BINN' and try again. DETACH USE [master] GO EXEC master.dbo.sp_detach_db @dbname = N'AdventureWorks', @keepfulltextindexfile = N'true' GO
