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