Quoted Identifiers

[CliveW]

SQL Server 2000 Std. W2K OS
Something strange happens to our system after a reboot with the quoted identifiers.

All the on the server databases do not have the quoted identfiers checked, within the Stored Procedures we set the quoted Identifiers ON when required.

Now after a reboot it appears that the Quoted Identifiers are reverted. For the Stored Procedures that has the Identifier set to ON within the procedure will not work, change the procedure to OFF and it works fine. Then after another reboot (whenever) it needs to be changed around again.
Please could someone tell me where to look and what to change to stop this from happening. This then causes more problems if you go to change an SP after this has happened.


Clive

 

[nigelrivett]

Why do you need to set it on?

Try sp_dboption after a reboot to see what the settings for the database are.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.