[AccessD] Pass thru Query - SQL Server

Not if I was your DBA.

You have no business changing column names from a pass-through query in a
production database.

And, something no one else said, no ; at the end of your statement.  SQL Server
does not use it and this is supposed to be straight SQL Server code, nothing
Access when you use a pass-through.


Robert L. Stewart
The Dyson Group International
Software for the Non-profit Enterprise
Expanding your Sphere of Knowledge


Quoting accessd-request at databaseadvisors.com:

> Date: Fri, 7 Jul 2006 11:09:26 -0500
> From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com>
> Subject: Re: [AccessD] Pass thru Query - SQL Server
> To: "Access Developers discussion and problem solving"
> 	<accessd at databaseadvisors.com>
> Message-ID:
> 	<F1DD538AE6BCE74EBE562DE51564D32201C76405 at houexch1.kindermorgan.com>
> Content-Type: text/plain; charset=us-ascii
>
> 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