Constraint Violating Yak Guru
Posted - 05/27/2013 : 23:16:01
| Dear Members
If one of my table i have write a trigger to insert records.i have insert records in sql query this is work fine. but i have insert a record in use application i got a following error in event viewer.this application connect a different sql username.i have done all the permission of user.
Event Type: Error
Event Source: Application Name
Event Category: Msql7_srv
Event ID: 1000
Time: 8:17:29 AM
Keyword MSQL Messages
Username username type S language 2
dbs_errno = 1297 Error 1297 occurred:
Error sqlcode 297 (sqlstate: 42000, Return code: -1, diagRecNum: 1) during SQLExecute.
[Microsoft][ODBC SQL Server Driver][SQL Server]The user does not have permission to perform this action.
Flushed at \db\servers\MSQL\msql_error.c : #504.
any one can help me what is error.
where i can permission of user