RE: [CF-Database] Problem with inserts

["Russ Michaels \(Snake\)" <snake.lists@snakepit.net>]

It was created by SA.
Yes I have an Identity column, it's an INT.
I have since discovered only SELECT queries are working, all others give
that error.
 

> -----Original Message-----
> From: database-bounces@list.cfdeveloper.co.uk 
> [mailto:database-bounces@list.cfdeveloper.co.uk] On Behalf Of 
> Steve Powell
> Sent: 28 December 2004 00:06
> To: database programming
> Subject: Re: [CF-Database] Problem with inserts
> 
> 
> Just out of interest was the DB created by the SA account or 
> by another account that is a member of db_owner. Have you got 
> an IDENTITY column? Is it an INT or a UUID? I've had problems 
> with the NEWID function in the past and permissions when 
> using unique identifier as a column type.
> 
> 
> 
> 
> ----- Original Message -----
> From: "Russ Michaels (Snake)" <snake.lists@snakepit.net>
> To: "'database programming'" <database@list.cfdeveloper.co.uk>
> Sent: Monday, December 27, 2004 10:24 PM
> Subject: [CF-Database] Problem with inserts
> 
> 
> >
> > I have a database where all inserts are giving me errors like this.
> >
> >  [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 
> > 'cfmx_helpdesk.ticketdata'.
> >
> > Cfmx_helpdesk is the DBO for all tables and has "database owner"
> > permissions. Selects and updates work fine.
> >
> > I really dunno why it is trying to reference the tables as 
> USER.TABLE 
> > just on inserts, as this is not in the code.
> >
> > I have recently changed this database to that the above user is the 
> > DBO instead of SA.
> >
> > Any ideas?
> >
> >
> > Russ
> >
> >
> >
> > --
> > For details on ALL mailing lists and for joining or leaving 
> lists, go 
> > to
> http://list.cfdeveloper.co.uk/mailman/listinfo
> >
> > --
> > CFDeveloper Sponsors and Supporters:-
> > >- Hosting provided by www.cfmxhosting.co.uk -<
> > >- Lists hosted by www.Gradwell.com -<
> > >- supporters:- www.apycom.com :  www.proworkflow.com -<
> > >- CFdeveloper is run and managed by Russ Michaels, feel free to 
> > >volunteer
> your help -<
> >
> >
> 
> 
> --
> For details on ALL mailing lists and for joining or leaving 
> lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
> 
> --
> CFDeveloper Sponsors and Supporters:-
> >- Hosting provided by www.cfmxhosting.co.uk -<
> >- Lists hosted by www.Gradwell.com -<
> >- supporters:- www.apycom.com :  www.proworkflow.com -<
> >- CFdeveloper is run and managed by Russ Michaels, feel free to 
> >volunteer your help -<
>