SQL User Error on Exec Stored Procedure
Posted on 2007-08-09
I am running SQL Server 2005 Express in my production environment, but for development I use SQL Server 2005 Standard to enable me to run profiler etc.
There are a number of errors I am trying to work out, and although I appreciate most are simply info messages, because I run the cut down express edition on my production server I really want to be able to rely on the perfmon SQL error counters to alert me to problems, and these info messages just confuse matters.
SQL User Error 1:
Cannot drop the table '#tmp_sp_db_vardecimal_storage_format', because it does not exist or you do not have permission.
This occurs frequently in the trace logs on my dev machine, and although I can't be sure it's happening outside of management studio or even at all on my live server....the trace show's it attempting to execute at least 4 times on most stored procedures. There is very little information available on this error it seems. Any ideas?
SQL User Error 2 & 3:
Changed database context to 'master'. (or whatever database)
Changed language setting to us_english.
So I know this is normal behaviour but can I turn off these Errors somehow? I would need to turn them off with confidence that the implications of doing so are understood.
In addition I will also be posting a question on Sort Warnings if anybody is interested.