Posted by Erland Sommarskog on 07/24/06 08:41

(prabhukumarasamy@gmail.com) writes:
> Now i m working in a existing project. I have to do some updations. In
> that project database table contain a table(usergroups) field name as
> 'Name'. When i am trying to insert a new record in (usergoups) table
> like as follows'
>
>
> insert into UserGroups(Name,modusr,moddt) values ('sam',131,'7/23/2006
> 10:02:13 PM')
>
>
> The response ll come as follows,
>
>
> Invalid column name 'FirstName'.Invalid column name 'LastName'.
>
> The usergroups table structure is as follows,
>
>
> UserGroupId int 4 (PK field)
> Name varchar 50
> modusr int 4
> moddt datetime 8
>
>
> Plz tell the correct insert query to add records for the above
> table....

Run the query in Query Analyzer. Pay particular notice the the "Procedure"
part of the message. I would bet that there is a trigger on the table
that has a problem.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]