dlmovies2004-03-12 15: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.