Re: sql script
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 25 Apr 2007 21:44:41 +0000 (UTC)
Brian (b.houghtby@xxxxxxxxxxxxxxxx) writes:
I must be doing something wrong, this is my error.
Msg 547, Level 16, State 0, Line 3
The UPDATE statement conflicted with the REFERENCE constraint
"FK_GL_TrnsLne_IMA". The conflict occurred in database "EAGLE", table
"dbo.GL_TrnsLne", column 'GLL_ItmID'.
The statement has been terminated.
One problem is that we don't know what you are doing. First you ask how
to do something, then you present an error message. That means that we
have to guess.
If you change 99l5555 to 99L5555 and this gives the error above, this
indicates two things:
1) This is a key value, and there are other table referencing that key
value.
2) The database uses case-sensitive or binary collation.
There are a couple of ways to go. One is to change the constraints
to have ON UPDATE CASCADE.
But it would help to know more about what you are trying to achieve.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
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
.
- References:
- sql script
- From: Brian
- Re: sql script
- From: Brian
- sql script
- Prev by Date: Joe Celko coming to Seattle
- Next by Date: Re: How to Generate all grants to a user role? (SQL Server 2000)
- Previous by thread: Re: sql script
- Next by thread: Re: sql script
- Index(es):
Relevant Pages
|
Loading
