期待着的博客

查看被锁表： select spId from master..SysProcesses where db_Name(dbID) = '数据库名称' and spId <> @@SpId and dbID <> 0 解除锁： exec ('Kill '+cast(@spid as varchar)) 查看被锁表 select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tabl

https://ola.hallengren.com/

--查询当前数据库备份进度 SELECTDB_NAME(er.[database_id]) [DatabaseName],er.[command] AS [CommandType],er.[percent_complete] ,er.start_time,CONVERT(DECIMAL(5, 2) , er.[percent_complete]) AS [Complete_Percent...

Lockrequesttimeoutperiodexceeded.(MicrosoftSQLServer，错误:1222) (2018-05-08 17:46:30) 转载▼ select * from master..SysProcesses where db_Name(dbID) = 'DM_CRS' and spId &...

declare @bak_sql varchar(2000) set @bak_sql ='BACKUP DATABASE '+'['+'db_name'+']'+' TO DISK = N'+''''+'F:\db_bak\db_name\db_name_fullbak'+ convert(varchar, getdate(), 112) +replace(convert(varchar,g...

--创建登陆帐户（create login） create login sp_read with password='sp_password', default_database=master --为登陆账户创建数据库用户（create user）,在mydb数据库中的security中的user下可以找到新创建sp_read create user sp_read for logi