Balkar Singh Kang

sqlserver probe - an object named '#temptab' in the database

Discussion created by Balkar Singh Kang Employee on Jun 18, 2018
Latest reply on Jul 16, 2018 by Balkar Singh Kang

I am getting the following error during the sql server monitoring. It appears like the temporary table used in query already exist in the database. I reviewed other communication posts which is referenceing to permission issues. Also Case number 00731668 has full query to collect the required data for this metric. 


Profile: da1w-agsql-t1_test_profile/fg_freeSpace_with_avail_disk/Run Query - DB Provider: Code=0x0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named '#temptab' in the database.



Can anyone help me with corrective steps and / or some workaround here?