... 3 11 SQL Server... 4 11.1... 7 11.2... 9 11.3... 11 11.4... 30 11.5 SQL Server... 30 11.6... 31 11.7... 32 12 SQL Mail... 33 12.1Windows NT... 33 12.2SQL Mail... 34 12.3SQL Mail... 34 12.4 Microsoft Exchange... 38 12.5 SQL Mail... 41
12.6SQL Mail... 41 12.7SQL Mail SQL Server Agent... 43 13 SQL Server... 46 13.1... 47 13.2... 48 13.3... 50 13.4... 51 13.5... 62 13.6... 63
11 SQL Server
11.1SQL Server
11.1
11.2 11.2.1
11.1
11.2 11.3
11.3.1SQL Server 11.3.2SQL Server SQL Server Agent MSDTC
11.2
11.3
11.3.3 SQL Server Windows NT
11.3.4 11.3.5 SQL Server SQL Server 7
11.4SQL Server
11.3.6 11.3
11.5SQL Server
11.3.7 11.4SQL Server 7
11.3.8
11.3.9Unicode
11.6SQL Server Unicode
11.3.10 11.3.11
11.7
11.3.12 11.3.13 11.5
11.6
11.3.14 11.7 11.3.15 SQL Server SQL Server Agent
11.4 11.5 SQL Server C: Mssql7 Binn Setup t RemoveAll = WARN
11.6 Setup t IniFilePath=setupinitializationfilename Setup?
11.7
12 SQL Mail 12.1Windows NT
12.2SQL Mail 12.3SQL Mail
12.3.1NT srvmgr servername
12.1
12.2MSSQLServer Windows NT
12.3.2Exchange 12.4 Microsoft Exchange
12.3SQL Mail
12.5 SQL Mail 12.6SQL Mail
12.6.1SQL Mail xp_startmail GO xp_stopmail GO
12.6.2 SQL Server xp_sendmail email_name, Any message you wish to send Mail Sent 12.7SQL Mail SQL Server Agent
12.4SQL Server Agent
13 SQL Server
13.1
13.2
13.3 13.3.1 4.2.1 13.3.2 6.0
13.3.3 6.5 13.4
13.1SQL Server Upgrade Wizard Data and Object Transfer
13.4.1 ( )
13.2
13.3 SQL Server ( )
13.4Version Upgrade Utility Database Creation Edit Advanced Drive Summary
13.5 SQL Server Upgrade Wizard
13.6Version Upgrade Utility Upgrade Completion
13.4.2 ( ) 13.5
13.6
13.6.1 13.6.2Hotfix
14 14.1
14.2
14.1 master
14.3 sp_configure Allow Updates, 1 GO RECONFIGURE WITH OVERRIDE GO
14.2 TransactSQL
14.3
14.4
14.4SQL
14.5SQL Server
14.6 SQL Server Agent (SQLAGENT.OUT)
14.7 SQL S erver Agent properties
14.4.1 14.4.2TechNet Knowledge Base Articles
14.4.3Microsoft
14.4.4SQL Server 14.4.5
14.4.6 14.4.7 SQL Server
14.5 14.5.1 14.5.1.1 RAID-0 RAID-5
14.5.1.2 RAID-1( ) 14.5.2
14.6
14.7 SQL Server
14.8
14.9
14.10 SQL Server
14.10.1 SQL Server
14.10.2SHUTDOWN SHUTDOWN WITH NOWAIT 14.11
15 15.1
15.1Database Maintenance Plan Wizard
15.2
15.2DBCC CHECKDB
15.2.1DBCC
15.3Microsoft TechNet Knowledge Base
15.4 Knowledge Base
15.2.2DBCC UPDATEUSAGE 15.2.3DBCC OPENTRAN
15.3 15.3.1
EXEC SP_CONFIGURE ALLOW UPDATES,1 RECONFIGURE WITH OVERRIDE BEGIN TRAN UPDATE sysdatabases SET status = status - 256 WHERE name = databasename AND status & 256=256 ROLLBACK TRAN EXEC SP_CONFIGURE ALLOW UPDATES,0 RECONFIGURE WITH OVERRIDE 15.3.2 RESTORE
15.4
15.5 15.5.1
15.5 Database Maintenance Plan Wizard
15.5.2 BACKUP DATABASE database_name TO database_device1 WITH INIT GO BACKUP DATABASE database_name TO database_devicel WITH DIFFERENTIAL
RESTORE DATABASE database_name FROM database_device1 WITH FILE = 1, NORECOVERY RESTORE DATABASE database_name FROM database_device1 WITH FILE = 2, NORECOVERY 15.5.3
15.6 New Job Properties
BACKUP LOG database_name TO LOG_device1 WITH INIT RESTORE DATABASE database_name FROM database_device1 RESTORE LOG database_name FROM log_device1 WITH RECOVERY
RESTORE LOG database_name FROM log_device1 WITH NORECOVERY RESTORE LOG database_name FROM log_device2 WITH RECOVERY 15.5.4
BACKUP DATABASE database_name TO database_device1, database_device2, database_device3,... RESTORE DATABASE database_name FROM database_device1, database_device2, database_device3,... 15.5.5
BACKUP DATABASE database_name file_or_filegroup,... TO backup_file,... WITH INIT RESTORE DATABASE database_name file_or_filegroup,... FROM backup_file,...
15.5.6 15.5.7
16 16.1Microsoft
16.1MS DTC Administrative Console
16.2
16.2.1DB-Library 16.2.2MS DTC Subscriber
16.2.3 Subscriber Publisher 16.2.4
16.3 16.3.1 REMOTE_PROC_TRANSACTIONS set remote_proc_transactions ON OFF
16.3.2REMOTE PROC TRANS sp_configure remote proc trans, 1 reconfigure with override
16.3.3MS DTC COM 16.4 sp_linkedserverssp_primarykeys
sp_catalogssp_indexes sp_column_privilegessp_table_privileges sp_columns_exsp_tables_ex sp_foreignkeys 16.5
sp_addserver remote_server_name 16.5.1 16.5.2
16.2
16.6 sp_addremotelogin { remoteserver }, login, remote_name
sp_addlinked server server2 GO sp_addlinked server Server1 GO sp_add remotelogin Server1, sa, sa GO sp_serveroption Server1, data access, TRUE GO sp_serveroption Server1, sa, sa, trusted, TRUE
17
17.1SQL Server Profiler 17.1.1 SQL Server Profile Queue
17.1SQL Server Profiler Queue
17.2SQL Server Profiler Trace Name
17.1.2
17.1.3 17.1.4
17.1.5
17.1.6 17.1.7
17.1.8TSQL 17.1.9
17.1.10
17.3SQL Server Profiler Trace Events
17.1.11 17.1.12
17.4SQL Server Profiler General
17.1.13 SQL Server 17.2SQL Server
17.2.1 SQL Server 17.2.2
sqlalrtr70 -E error_number -S server_name -P password -D database_name -V severity -T
17.5
17.6SQL Server Agent New Alert
17.2.3
17.2.4 17.2.5 SQLServer
18 18.1
18.2
18.2.1
18.2.2
18.2.3
18.2.4 18.3
18.3.1
18.3.2
18.3.3 18.1 OR
18.2 AND
18.3 OR AND
18.4
18.4
18.5 (VLDB) 18.6
18.7
18.8
18.8.1 18.8.2
18.9
19 Transact-SQL
19.1 SELECT* FROM MyAccountTable WHERE Past_Due_Amt > 100000 SELECT* FROM CustomerTable
WHERE CustomerID = 3876098 SELECT name FROM sysobjects WHERE type = U ORDER BY name 19.2
CREATE PROCEDURE MajorPastDue AS SELECT* FROM MyAccountTable WHERE Past_Due_Amt > 100000 GO EXECUTE MajorPastDue
CREATE PROCEDURE ProcWithParm @ customer_id int AS SELECT Customer_Name FROM Customer WHERE Customer_ID = @customer_id EXECUTE ProcWithParm 10034 Description: UpdStatsAll is a stored procedure that uses a cursor to run Update Statistics on every table in the database. Execute this stored procedure in a user database.
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id ( dbo.updstatsall ) BEGIN ANDtype = P ) END GO GO AS PRINT Create Procedure UpdStatsAll CREATE PROCEDURE UpdStatsAll DECLARE @table_name varchar(128), @ table_name_msg varchar(95), @ errmsg varchar(85) SELECT Starting Update Statistics,getdate() DECLARE cursor1 CURSOR FOR SELECT name FROM sysobjects WHERE type = U ORDER BY name OPEN cursor1
FETCH NEXT FROM cursor1 INTO @table_name WHILE(@@FETCH_status<> -1) BEGIN IF (@@FETCH_status<> -2) BEGIN SELECT @table_name_msg = System is running Update Statistics on RTRIM(@table_name) END ELSE END PRINT @ table_name_msg EXEC( UPDATE STATISTICS @table_name) BEGIN SELECT @errmsg = FETCH error has occurred. GOTO err_rtn FETCH NEXT FROM cursor1 INTO @table_name END SELECT Finished with Update Statistics, DEALLOCATE cursor1 RETURN getdate()
err_rtn: DEALLOCATE cursor1 RAISERROR 500000 @errmsg RETURN - 100 GO 19.3 IF EXISTS (SELECT name FROM sysobjects WHERE name = CustChgTr AND type = TR ) DROP TRIGGER CustChgTr GO CREATE TRIGGER CustChgTr ON Customer FOR INSERT, UPDATE, DELETE
AS EXEC master..xp_sendmail CUSTSERV, The data in the customer table has changed. GO IF EXISTS (SELECT name FROM sysobjects WHERE name = reminder AND type = TR ) DROP TRIGGER reminder GO CREATE TRIGGER MyTrigger ON MyTable FOR INSERT, UPDATE AS DECLARE @MyFlag tinyint SELECT @MyFlag = d.disc_type FROM Artist a INNER JOIN inserted i ON a.art_id = i.art_id JOIN Discipline d ON d.disc_id = i.disc_id IF (@MyFlag = 0 )
BEGIN RAISERROR ( This artist does not have a discipline.,16,-1) ROLLBACK TRANSACTION END 19.4
19.4.1 I O 19.4.2 I O 19.5
19.6 19.7SHOWPLAN
SET SHOWPLAN_TEXT ON SET SHOWPLAN_ALL ON 19.7.1SHOWPLAN
19.8
19.8.1 19.8.2
19.8.3 19.9Tempdb
19.10 DECLARE cursor1 CURSOR FOR SELECT name FROM sysobjects WHERE type = U ORDER BY name OPEN cursor1 FETCH NEXT FROM cursor1 INTO @table_name WHILE (@@FETCH_status <> -1) BEGIN IF (@@FETCH_status <> -2)
DEALLOCATE cursor1 RAISERROR 500000 @errmsg RETURN -100 GO
19.11
19.12
20
20.1 20.1.1
20.1.2
20.2
20.3Microsoft OLAP Server
20.3.1 20.3.2Desktop Data Cube Service
20.3.3 20.3.4Microsft OLAP Manager
20.3.5