Could not find stored procedure 'SP_DBOPTION'.

Hi All,
Command:
SP_DBOPTION 'ORDERDB', 'SELECT INTO', 'TRUE'
Error Message:
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'SP_DBOPTION'.
I am getting the above message when I run the said
command. I tried to locate the resolution at several
places and no help
Thanks,
Mohammed Sarwar
Ocp Dba Oracle 9i, 8i, 8.0If you have a case-sensitive installation, you need to specify the
stored procedure name in lower case:
EXE sp_dboption 'ORDERDB', 'SELECT INTO', 'TRUE'
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Mohammed Sarwar" <MSarwar@.uBid.com> wrote in message
news:29fe001c391dd$1012bfd0$a601280a@.phx.gbl...
> Hi All,
> Command:
> SP_DBOPTION 'ORDERDB', 'SELECT INTO', 'TRUE'
> Error Message:
> Server: Msg 2812, Level 16, State 62, Line 1
> Could not find stored procedure 'SP_DBOPTION'.
> I am getting the above message when I run the said
> command. I tried to locate the resolution at several
> places and no help
> Thanks,
> Mohammed Sarwar
> Ocp Dba Oracle 9i, 8i, 8.0
>|||Dan,
Super! That worked.
Thanks,
Mohammed Sarwar
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!