小祝的专栏

SQL Server清理日志USE [master]GOALTER DATABASE 数据库 SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE 数据库 SET RECOVERY SIMPLE --简单模式GOUSE 数据库GODBCC SHRINKFILE (N'逻辑名' , 1000, TRUNCATEONLY) --设...

--获取所有表名select * from sysobjects where xtype='U' order by name --获取所有字段名select * FROM syscolumns where id=object_id('TableName')

SELECT a.name, b.rowsFROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.idWHERE (a.type = 'u') AND (b.indid IN (0, 1))ORDER BY b.rows DESC

ALTER TRIGGER [tr_connection_limit]ON ALL SERVER WITH EXECUTE AS 'sa'FOR LOGONASBEGINIF ORIGINAL_LOGIN()= 'sa'--允许sa在本机和下面的IP登录AND(SELECT EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', ...

select t2.name as 数据库名,t3.client_net_address as ip地址,t1.host_name as 电脑名 from master.sys.dm_exec_sessions t1inner join master.dbo.SYSDATABASES t2 on t1.database_id=t2.dbidinner join master.sys.dm_...