Re: [CF-Database] Problem with inserts

["Steve Powell" <steve@powell.net>]

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