Sql

RESTORE DATABASE [databasename] WITH RECOVERY

USE master;
GO

ALTER DATABASE Database_name
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;

USE master;
GO

ALTER DATABASE Database_name
SET MULTI_USER;
GO

PREVIOUS	NEXT

Code Example
Sql :: database name
Sql :: NLS_NCHAR_CHARACTERSET
Sql :: downgrading sql localdb visual studio
Sql :: automated psql csv export script on windows
Sql :: Getting error while running 50 MB script on SQL Server
Sql :: CREATE MULTIPLE FK
Sql :: Postpresql relation not found
Sql :: sütun güncelleme SQL
Sql :: BigQuery: join 2 tables but only choosing rows based on date column
Sql :: migration to create a gender in the database table
Sql :: SQL INNER JOIN With AS Alias
Sql :: Using Set<Id in Dynamic SOQL
Sql :: mysql – Error ‘Column count of mysql.user is wrong. Expected 45, found 43. The table is probably corrupted’ on query.
Sql :: Laravel: customize or extend notifications - database model
Sql :: select from another database
Sql :: python sqlalcahmey compare datetime using extract
Sql :: python sql last insertend
Sql :: database traccar
Sql :: Every Derived yable must have its own alias
Sql :: sql statement checker corrector
Sql :: select save as table postgres
Sql :: having all mysql
Sql :: sql get frist of month
Sql :: oracle connection
Sql :: PBI TO SQL
Sql :: add alternate add column sql
Sql :: python sqlalcahmey compare datetime using AND_ or OR_
Sql :: sql date time query find
Sql :: mysql read row
Sql :: funktion LOWER/UPPER sql