Microsoft SQL Server ¹ÜÀí £¨³£ÓùÜÀí¼°Î¬»¤ÃüÁ

 --²éѯµ±Ç°Á¬½ÓµÄʵÀýÃû
select @@servername--²ì¿´ÈκÎÊý¾Ý¿âÊôÐÔ
sp_helpdb master
--ÉèÖõ¥Óû§Ä£Ê½£¬Í¬Ê±Á¢¼´¶Ï¿ªËùÓÐÓû§
alter database Northwind set single_user with rollback immediate--»Ö¸´Õý³£
alter database Northwind set multi_user
--²ì¿´Êý¾Ý¿âÊôÐÔ
sp_helpdb--²ì¿´Êý¾Ý¿â»Ö¸´Ä£Ê½
select databasepropertyex('Northwind','recovery')--ÉèÖÃ×Ô¶¯´´½¨Í³¼Æ
alter database Northwind set auto_create_statistics on/off--ÉèÖÃ×Ô¶¯¸üÐÂͳ¼Æ
alter database Northwind set auto_update_statistics on/off--²é¿´×÷ÒµÁбí
select * from msdb..sysjobs--²é¿´×÷ÒµÏêϸÐÅÏ¢
exec msdb..sp_help_job @job_name = 'HQCRM-CrmNew-CrmNew_2Dimension-NANJINGCRM-216'--ÐÞ¸Ä×÷ÒµÐÅÏ¢
exec msdb..sp_update_job @job_id = 0x4CA27521C9033C48954E7BFC6B965395, @enabled = 1--²ì¿´·þÎñÆ÷½ÇÉ«
exec sp_helpsrvrolemember--Ìí¼Ó·þÎñÆ÷½ÇÉ«
exec sp_addsrvrolemember 'member_name','sysadmin'--ɾ³ý·þÎñÆ÷½ÇÉ«
exec sp_dropsrvrolemember 'member_name','sysadmin'--²ì¿´Êý¾Ý¿â½ÇÉ«
exec sp_helprole--Ìí¼ÓÊý¾Ý¿â½ÇÉ«
exec sp_addrole 'role_name'--ɾ³ýÊý¾Ý¿â½ÇÉ«
exec sp_droprole 'role_name'--²é¿´Óû§ÐÅÏ¢
exec sp_helpuser--×¢Òâɾ³ýguestÕÊ»§
use dbname
go
exec sp_dropuser guest
--Ð޸ĶÔÏóÓµÓÐÕß
exec sp_changeobjectowner 'old_onwer.table_name', 'new_owner'
--²é¿´BUILTIN\AdministratorsÕʺÅ
exec master..xp_logininfo 'BUILTIN\Administrators', 'members'--ÐÞ¸ÄĬÈÏÊý¾Ý¿â
exec sp_defaultdb 'login', 'defaultdb'--´´½¨Ðµĵǽ
exec sp_addlogin @loginame = 'esProgram',@passwd = 'h1J2P97vfdlK34',@defdb = 'career'
--¸ü¸ÄµÇ½Êý¾Ý¿â·ÃÎÊȨÏÞ
use <dbname>
exec sp_grantdbaccess @loginame ='esProgram',@name_in_db = 'esProgram'
--°Ñ½ÇÉ«db_appuserÌí¼ÓÓû§ÕʺÅÖÐ
use <dbname>
exec sp_addrolemember @rolename = 'db_appuser',@membername = 'esProgram'--Ô¤²âÔö³¤
use master
/* Procedure for 8.0 server */
create proc usp_databases
as
set nocount on
declare @name sysname
declare @SQL nvarchar(600)/* Use temporary table to sum up database size w/o using group by */
create table #databases (
      D