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?
Thanks
Balkar