SqlServer管理方面

用户、组或角色 ‘’ 在当前数据库中已存在

sp_change_users_login ‘update_one’, ‘AAA’, ‘AAA’

注：其中update_one是存储过程的参数，
表示只处理一个用户，前一个AAA是“用户”，
后一个AAA是“登录”，
以上这个SQL表示将服务器登录“AAA”与数据库用户“AAA”重新连接起来。

SqlServer数据库收缩

--设置为简单模式
ALTER DATABASE ASFCORE SET Recovery simple

--收缩日志文件大小(单位是M)
DBCC SHRINKFILE (N'ASFCORE_log' , 10)

表统计

SELECT  a.name AS [TABLE NAME] ,
        b.rows AS [RECORD COUNT]
FROM    sysobjects AS a
        INNER JOIN sysindexes AS b ON a.id = b.id
WHERE   ( a.type = 'u' )
        AND ( b.indid IN ( 0, 1 ) )
ORDER BY a.name ,
        b.rows DESC

谁在连接sqlserver？

--谁在连接sqlserver？
SELECT [dec].client_net_address,
       [des].[program_name],
       [des].[host_name],
       Count([dec].session_id) AS connection_count
FROM   sys.dm_exec_sessions AS [des]
       INNER JOIN sys.dm_exec_connections AS [dec]
               ON [des].session_id = [dec].session_id
GROUP  BY [dec].client_net_address,
          [des].[program_name],
          [des].[host_name]
ORDER  BY [des].[program_name],
          [dec].[client_net_address];