We are using MP2 (Maintenance Program) that pulls information from a SQL server for reports. About once a week, someone will get the message: "There is an object named 'Report ##4' in the database. At that time, we have to restart the SQL Manager. Has anyone ever heard of anything like this. I don't even know where to begin to look.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Microsoft SQL Server
- Thread starter phongirl
- Start date
The double digit "##' indicates that someone is creating a GLOBAL temporary table somewhere within your application. Since it is GLOBAL, it will remain in effect until ALL connections to it are terminated or you drop the table. While that table exist, the application is trying to create the table again causing your error. Try searching your stored procedures (hopefully your application uses stored procedures for all report accesses) to find "##4" and you will probably find the culprit. Also, for each place where you create Temporary tables, check to see if they exist at the beginning of the code. This will help avoid this issue later on.
Hope this helps.
Hope this helps.
- Status
Similar threads
- Question
