aurato (7/21/2014)
I restarted my server's SQL Service when I could not kill a connection for nearly an hour. This caused many issues....
2) After the restart, tempdb and the model database had no tables. This caused an issue in our Great Plains 9 system where it was dependent upon two tempdb tables DEX_LOCK and DEX_SESSIONS. I created these tables with an online script from the GP website and that began to function again.
After any other given restart, when tempdb is recreated, it has no tables. Ditto with model.
...
The [tempdb] is re-created whenever the SQL Service is started.So it cannot hold permanent tables inside. Perhaps the tables you mentioned were created by a stored procedure that runs automatically when the service is started. See this link for more information: http://msdn.microsoft.com/en-us/library/ms181720.aspx