Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2013-05-27 : 23:16:01
|
| Dear MembersIf 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: ErrorEvent Source: Application NameEvent Category: Msql7_srv Event ID: 1000Date: 5/28/2013Time: 8:17:29 AMUser: computername\usernameComputer: computernameDescription:Env (d:\app-path)Keyword MSQL MessagesUsername username type S language 2Process 0x1fe4Lasterror 0Errno 0bdberrno 0Message 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 |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
|
|
|
permission of user in sql