I am trying to run a stored procedure which may create temporary tables. When I try to run it it gives the following error message:
Executed as user: NT AUTHORITY\SYSTEM. Invalid object name '9b9e4463b6344b849407fc65a21b5d47PolicyResults1'. [SQLSTATE 42S02] (Error 208). NOTE: The step was retried the requested number of times (1) without succeeding. The step failed.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed