Expect the UnExpected

In the world of production DBA some great genious (this is called self boasting) said always expect the unexpected..I recently hit that thing again. We started hearing that the application is throwing some error like "No Record found" even though the records exists. Later we found out that in every exception the programmers (of a company Powered by intellectuals hahaha..very funny isint) have given a message "Records Not Found". Initially the application team said like its due time out error and we keep looking for a reason across all our environment.

Atlast I gave the option of profiler to check for errors and the flow of stored procedure. Alas we found out.. they are creating global temp tables on each connection with a fixed name and if two connections are calling that stored proc one is failing with the error temp table already exists.. and they are nicely displaying the message "Record Not Found" sweet isint..tats why i say expect the unexpected always :)..

Any have happy admnistrating..catch on another occassion soon until then its hv fun..its me logging off frm blogger ;)

With Smiles

santhosh