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 |
|
khatchik
Starting Member
9 Posts |
 Posted - 2001-02-01 : 14:42:49
|
| I have a Store procedure that runs every second. This procedure was compiled by DBO, however, it is called by another user that has execute permissions only. My DBA says that this is causing Deadlocks due to "[[compile]] locks." Furthermore, he suggests that I call the store procedure with Dbo idendifier. For example, "exec pubs.dbo.myProc."Does anyone have any other suggestions.Thankschris isayan |
|
|
|
|
|
blocking due to [[compile]] locks