I don't want to make any database level changes, just reset the options for the connection so I don't think any ALTER DATABASE commands would help.

I'll take a look...

Thanks for the response.

As far as I understand sp_configure is used for changing server level settings, I just want to restore the connection level settings (ANSI_NULLS etc) to the defaults...