When i execute an sp am getting the below message.
"Database name 'tempdb' ignored, referencing object in tempdb."
In this sp am creating and dropping some temp tables. I understood, because of dropping the temp tables am getting this message. But since it has the loop involved, am getting the message for n number of times.
Can any one advice me on this how to stop getting this warning kind of message which is no longer useful for me.