Kaup, Chester
Chester_Kaup at kindermorgan.com
Fri Jul 7 11:09:26 CDT 2006
I will have to check with the DBA about my rights. Is there another way to change a field name in an SQL table with a pass through query? This is new territory for me. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Maddison Sent: Thursday, July 06, 2006 9:49 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Pass thru Query - SQL Server Its system sp. (sp_) Make sure your login has ddladmin permissions... >From BOL Members of the sysadmin fixed server role, the db_owner and db_ddladmin fixed database roles, or the owner of the object can execute sp_rename. Only members of the sysadmin and dbcreator fixed server roles can execute sp_rename with 'database' as the object_type. Does the sp run from QA? cheers Michael M On 6 Jul 2006 at 15:52, Kaup, Chester wrote: > Answers to your questions below. How about posting the sp? -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com