When you modify the schema, are you performing this from a cfquery block? If you are, put the schema modification in a stored procedure for purposes of security, speed and abstraction.
Teddy On 10/3/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > > I've seen that happen on a database that was moved from one server to > another where user names/passwords were different in the Enterprise > Manager/CF Admin. > > Check those first... should be pretty easy to spot. Open the enterprise > manager and view the tables in that particular database.... scan down the > owner column and look to see if any stick out with a different name. The > chances are good that your new table will have a different owner than the > rest. > > -----Original Message----- > From: Derek Bezuidenhout [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 03, 2006 9:50 AM > To: CF-Talk > Subject: SQL 'Invalid Object Name' on Insert, after Create Table > > Hey folks, > I'm having trouble with inserting into a table I've just created. > > As a summary of what I'm doing: > - if the table exists, delete it > - create the table > - read from the table to prove it's there > - insert into the table > *splat* : "Invalid object name..." > > I can post the full code and error if you want. > > All the other forum posts around the web say things like: > - check the user permissions > - the user in the datasource has db_owner, and for good measure > db_datawriter, db_datareader. > - reference the table in the INSERT with the owner (ie: dbo.tablename) > - I've gone so far as to look up the owner in sysobjects > - if using JDBC driver then set selectMode=cursor > - done > > Thought it might be related to http://support.microsoft.com/kb/837970/ so > I'm now running this on a different new fresh SQL server, with SP4 > installed. > > The same error occurs on CF5 and CFMX7. > > Even when I try the Insert without the Create Table it fails. (ie: run > once > so table is created, then rem out the Create Table bit and run it again.) > > All suggestions welcome... > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
