开发者

A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement

开发者 https://www.devze.com 2022-12-26 17:03 出处:网络
I\'m working on a online game. I got some problems with inserting new data to table. I\'m getting 2010-4-8 2:14, 37000, 513,

I'm working on a online game. I got some problems with inserting new data to table. I'm getting

2010-4-8 2:14, 37000, 513, [Microsoft][ODBC SQL Server Driver][SQL Server]A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database 'KN_online', table 'ACCOUNT_CHAR', column 'strAccountID'., 261 NationSelect

in logs. What does this means? How can i fix this?

I've tried to delete RULE for my DB but I'm unable to delete RULE. I'm getting the rule 'dbo.unallo开发者_开发百科wedchars' cannot be dropped because it is bounded to one or more clumn.

I set all permissions right but its still not working.. thanks..


You'd want to:

a) Understand why someone bound the rule in the first place. If you don't know why the rule is there, I'd suggest a bit of investigation before proceeding. Are you going to break some other area of the application by putting in inappropriate characters?

b) Use the stored procedure sp_unbindrule (2008 link, but applies to 2000 equally well), to unbind the rule from the column.

0

精彩评论

暂无评论...
验证码 换一张
取 消