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 |
|
Carat
Yak Posting Veteran
92 Posts |
 Posted - 2008-10-08 : 06:49:12
|
| I created an Event Notification on several Eventtypes. One of them is the Eventtype USER_ERROR_MESSAGE. I also created a service and a queue that is capturing these events (Service Broker). I will only capture events where the Severity is higher than 11 and these are logged in a table. In my table I got 340 records on one week time of the same error:"Cannot drop the table '#tmp_sp_db_vardecimal_storage_format', because it does not exist or you do not have permission."The Loginnames with these events are both Sysadmins and Non-sysadmins so they should have permission to drop this temporary table.Has anyone got an idea?This problem occurs on our production system with SQL Server 2005 Enterprise Edition Service Pack 2. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-08 : 08:24:49
|
| It might be that Someone is trying to delete temp table which is created by table variable or SQL 2005 features that use TEMPDB(like online indexing,DBCC checkdb,Sorting,Hash join......)or Explicitly dropping Temp table which has already been dropped. |
 |
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2008-10-08 : 09:10:20
|
| Thanks.I will use a trace to analyze this. |
|
|
|
|
|
|
#tmp_sp_db_vardecimal_storage_format