f64, 有事請教,先謝過.

來源: 於 2004-03-12 07:05:07 [舊帖] [給我悄悄話] 本文已被閱讀：次

This is related to an old question you answered previously about SQL server 2000.
The question was how to set up the SQL server so that XACT_ABORT will be set to ON automatically once the server is turned on. I tried your way, however,
"exec sp_procoption N'spName', N'startup', N'true'" can only be applied to sprocs in Master database. The rest of databases are not affected and hence the flag for XACT_ABORT was still set to "OFF". Any suggestion will be greatly appreciated. Thanks again.