- 博客(2)
- 收藏
- 关注
转载 How to monitor tempdb in MS SQL
Error: tempdb is full due to active_transaction. 1 select 2 ss.[host_name], 3 ss.login_name, 4 ss.original_login_name, 5 ss.[status], 6 R.* 7 from( 8 SELECT COALESCE(T1...
2018-10-17 10:53:00
66
转载 drop all database objects
/*Use this sql to drop all objects in a database.*/ -- Drop all SPdeclare @dropSp varchar(max)=''select @dropSp=@dropSp+'DROP PROCEDURE '+QUOTENAME(SCHEMA_NAME(obj.schema_id))+'.'+ QUOTENAME(RTR...
2017-03-16 11:51:00
151
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人