page 291 to page 311.txt

Sql statement it is very cute

EXEC sp_configure 'c2 audit mode', 1
RECONFIGURE


USE Sample
SELECT * FROM Employees
USE Northwind
SELECT * FROM Customers


EXEC sp_configure 'c2 audit mode', 0
RECONFIGURE


DBCC CHECKDB ('Sample')


DBCC CHECKDB ('Sample', REPAIR_REBUILD)


USE Northwind
EXEC sp_helpindex 'Suppliers'


DBCC SHOWCONTIG ('Suppliers','PK_Suppliers')


EXEC sp_detach_db 'Northwind'


USE Northwind


EXEC sp_attach_db 'Northwind', 'C:\northwnd.mdf', 'C:\northwnd.ldf'


USE Northwind
SELECT * FROM Suppliers