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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  sp_dboption with SELECT INTO

Author  Topic  Beefy Starting Member 21 Posts Posted - 2001-02-27 : 08:15:01 Lame question 2, SQL is complaining when I run a SELECT INTO qry. Server: Msg 268, Level 16, State 3, Procedure sp_something, Line 3 Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option. Whats the deal there? I am using user sa. What option do I change to make the SELECT INTO work. Many Thanks in advance. Beefy ..... Women may well be able to fake orgasms, but men can fake whole relationships .....