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.