[dba-SQLServer]Permission to My Own Table

sp_dboption your_db_name, 'select into', true

Robert Djabarov
Senior SQL Server DBA
USAA IT/DBMS
? (210) 913-3148 - phone
? (210) 753-3148 - pager


 -----Original Message-----
From: 	Nicholson, Karen [mailto:knicholson at gpsx.net] 
Sent:	Thursday, June 26, 2003 1:25 PM
To:	dba-SQLServer at databaseadvisors.com
Subject:	[dba-SQLServer]Permission to My Own Table

Dumb question. I created a new table in an SQL application.  I can not use
the table, it is telling:

Server: Msg 268, Level 16, State 3, Procedure gps_proactive_XALPRO, Line 289
Cannot run SELECT INTO in this database. The database owner must run
sp_dboption to enable this option.

I have set all the permissions in the table for the whole world up update,
select, etc.  What the?  I am sure this is something really easy.  Thanks.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com