April 30, 2007 at 2:47 pm
Hi,
we have a global temp table that was created long ago in sql server 2000. when we moved to sql server 2005 the global temp table is also moved. But when I try to delete that table it is not getting deleted. Is there a way to forcibly delete that temp table? We are not able to run the backups because of that.
Thanks,
sridhar.
April 30, 2007 at 3:03 pm
The TempDB gets rebuilt each time you restart the SQL Server Service so this seems strange that a global temp tables remains. How exactly is this impacting your backups?
April 30, 2007 at 3:23 pm
I created a maintenance plan with check Integrity option selected. It is failing at that point. And it is not backing up the databases.
April 30, 2007 at 3:27 pm
April 30, 2007 at 3:34 pm
Executing the query "UPDATE STATISTICS [dbo].[##temptable]
" failed with the following error: "Table '##temptable' does not exist.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
April 30, 2007 at 4:04 pm
It looks like this is a duplicate post to your other thread here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=361181
For the short term, I would suggest making changes to your maintenance plan so that you are getting valid backups. Then keep working down the path the guys in the other post have you doing. It does seem that we may be missing some information here. You say that this table came over from SQL Server 2000 to SQL Server 2005? How is that possible? Moving a user has zero impact on the TempDB? Can you elaborate? Please reply in the other thread.
This thread should be considered CLOSED!! Please continue dialog in the above posted thread.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply