I need to know the completely description of this error. It appears in
sysmessages table
so:
"%ls statement conflicted with %ls %ls constraint '%.*ls'. The conflict
occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls."
I need to know exactly what kind of values can have this parameters.
Can anybody help me? Please ...
It is very important for me and I didn't know where can I find this info
-enci-Try this.
use pubs
go
SELECT * FROM titles
UPDATE titles
SET pub_id = -1
WHERE title_id = 'BU1032'
It will give you the Error
Server: Msg 547, Level 16, State 1, Line 1
UPDATE statement conflicted with COLUMN FOREIGN KEY constraint
'FK__titles__pub_id__014935CB'. The conflict occurred in database 'pubs',
table 'publishers', column 'pub_id'.
The statement has been terminated.
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Eniko Tegen" <EnikoTegen@.discussions.microsoft.com> wrote in message
news:EB3F91DF-0B9D-4CB3-A57A-2C005F6D65FF@.microsoft.com...
>I need to know the completely description of this error. It appears in
> sysmessages table
> so:
> "%ls statement conflicted with %ls %ls constraint '%.*ls'. The conflict
> occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls."
> I need to know exactly what kind of values can have this parameters.
> Can anybody help me? Please ...
> It is very important for me and I didn't know where can I find this info
>
> -enci-|||Thanks.
But it doesn't exist an exactly documentation for this error? I mean, I
can't try the all existing cases in which this error appears, cause I don't
know in which cases it appears. I know that it apears in minimum 2 cases:
foreign key-s and check constraint-s. But in every cases(for this 2), there
are diferrent messages for insert, update or delete.
-enci-
"Roji. P. Thomas" wrote:
> Try this.
> use pubs
> go
>
> SELECT * FROM titles
> UPDATE titles
> SET pub_id = -1
> WHERE title_id = 'BU1032'
> It will give you the Error
> Server: Msg 547, Level 16, State 1, Line 1
> UPDATE statement conflicted with COLUMN FOREIGN KEY constraint
> 'FK__titles__pub_id__014935CB'. The conflict occurred in database 'pubs',
> table 'publishers', column 'pub_id'.
> The statement has been terminated.
>
> --
> Roji. P. Thomas
> Net Asset Management
> https://www.netassetmanagement.com
>
> "Eniko Tegen" <EnikoTegen@.discussions.microsoft.com> wrote in message
> news:EB3F91DF-0B9D-4CB3-A57A-2C005F6D65FF@.microsoft.com...
>
>|||Thanks.
But it doesn't exist an exactly documentation for this error? I want to know
exactly how many cases are when this error apears to can make an exactly
translation for this error. I know that this message appears in minimum 2
cases: foreign keys and check constraint, but in every cases from this, it
appears diferent error messages for insert/update/delete operations.
I can't try the all cases if I don't know which are there. :-(
-enci-
"Roji. P. Thomas" wrote:
> Try this.
> use pubs
> go
>
> SELECT * FROM titles
> UPDATE titles
> SET pub_id = -1
> WHERE title_id = 'BU1032'
> It will give you the Error
> Server: Msg 547, Level 16, State 1, Line 1
> UPDATE statement conflicted with COLUMN FOREIGN KEY constraint
> 'FK__titles__pub_id__014935CB'. The conflict occurred in database 'pubs',
> table 'publishers', column 'pub_id'.
> The statement has been terminated.
>
> --
> Roji. P. Thomas
> Net Asset Management
> https://www.netassetmanagement.com
>
> "Eniko Tegen" <EnikoTegen@.discussions.microsoft.com> wrote in message
> news:EB3F91DF-0B9D-4CB3-A57A-2C005F6D65FF@.microsoft.com...
>
>
