廣告：

USE master;
GO

-- 假設你的數據庫文件名為 'YourDatabase.mdf'，且日志文件名為 'YourDatabase_log.ldf'
-- 如果只有 MDF 文件，則日志文件參數可以省略
EXEC sp_attach_db @dbname = N'AIS20151222101610',
@filename1 = N'G:\temp\20240618\AIS20151222101610_Data.mdf';

USE MASTER;
GO;
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='AIS20151222101610'
Go
sp_dboption 'AIS20151222101610', 'single user', 'true'
Go
DBCC CHECKDB('AIS20151222101610')
DBCC CHECKDB(AIS20151222101610,REPAIR_ALLOW_DATA_LOSS)
Go
update sysdatabases set status =28 where name='AIS20151222101610'
Go
sp_configure 'allow updates', 0 reconfigure with override
Go
sp_dboption 'AIS20151222101610', 'single user', 'false'
Go

以上命令如果出錯，請一行一行執行。 查詢分析器里面執行。

sql2000導入腳本命令：

osql -S HAO-PC\SQL2001 -U sa -P 123456 -d AIS20151222101610 -i G:\temp\index4.sql

其他版本用：SQLCMD

查找某個表的觸發器:

SELECT name AS '觸發器名稱', OBJECT_NAME(parent_id) AS '關聯表', type_desc AS '觸發器類型', OBJECT_DEFINITION(object_id) AS '觸發器定義'
FROM sys.triggers
WHERE parent_class = 1 AND OBJECT_NAME(parent_id) = 'YourTableName';

如：

SELECT name AS tname, OBJECT_NAME(parent_id) AS ttable, type_desc AS ttype, OBJECT_DEFINITION(object_id) AS tdefine
FROM sys.triggers
WHERE parent_class = 1 AND OBJECT_NAME(parent_id) = 'a_user';

廣告：