Hi Richard,

I can assure you it isn't the ODBC driver. I create both SQL Databases and SQL tables in the SQL Server from metadata, as part of our build process, which is used quite regularly. As Sergey indicates, it's a credentials and role assigned to those credentials issue.

Hank

>Hi to All
>
>Thanks to all who have provided assistance to my problems in the past.
>
>I have a situation where I need to "SELECT * INTO new_table FROM existing_table"
>
>No matter how I have tried to GRANT 'CREATE TABLE' rights to the users and or roles, I get the following error.
>"Create table permission denied in database mydatabase"
>
>Is the problem systemic with respect to my using ODBC 32 as the pass-through middle-ware or is it a fixable problem in my VFP calling command or in SQLMS?
>
>I have also used it in Win XP standalone, Win Server 2008 and with SQL Server 2005 and SQL Server 2008 R2.
>
>Any help or ideas are welcome.
>Thanks again very much
>Rich Balluff
>RLB Associates