Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-22 : 08:10:42
|
| S.Faizal khan writes "I changed the configuration settings of MS-SQL Server6.5 using the command 'sp_configure 'user options',150 go RECONFIGURE WITH OVERRIDE go'After that i am not able to open MS-Sql Enterprise Manager.So now i am trying to reset the user options using the command sp_configure 'user options',0.goRECONFIGURE WITH OVERRIDEgoBut while executing this 'RECONFIGURE WITH OVERRIDE' command,the following error is coming.'Msg 226, Level 16, State 2CONFIGURE command not allowed within multi-statement transaction.How to rectify this error ? Pls help ASAP." |
|
|
|
|
|
Unable to use Reconfigure command in SQL Server