I have only read permission to the client database I'm querying in. The same query was working for since yesterday but today I am encountering the below error in sql server management studio. "The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases" Any thoughts or suggestions on what the cause is or how to resolve it is much appreciated. Thanks in advance!!
The usual suspect is that the drive is out of space. Have you checked that? If the drive runs out of space and the transaction log attempts to grow due to a large transaction it won't be able to and you'll get that error message. I would try to expand the drive to handle the growth of tempdb. Hope that helps!