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
Dick Balluff