Getting this error ... tempdb.dbo.ASPStateTempApplications'

[athishay1]

Invalid object name = 'tempdb.dbo.ASPStateTempApplications'.
An unhandled exception was generated during the execution of the current = web request. Information regarding the origin and location of the = exception can be identified using the exception stack trace = below.
Stack Trace:


[SqlException (0x80131904): Invalid object name =
'tempdb.dbo.ASPStateTempApplications'.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, =
Boolean breakConnection) +95
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException =
exception, Boolean breakConnection) +82
=
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateOb=
ject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, =
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet =
bulkCopyHandler, TdsParserStateObject stateObj) +3244
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader =
ds, RunBehavior runBehavior, String resetOptionsString) +186
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior =
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean =
async) +1121
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior =
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String =
method, DbAsyncResult result) +334
=
System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult =
result, String methodName, Boolean sendToPipe) +407
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +149
System.Web.SessionState.SqlPartitionInfo.InitSqlIn fo(SqlConnection =
sqlConnection) +379
System.Web.SessionState.SqlStateConnection..ctor(S qlPartitionInfo =
sqlPartitionInfo) +545
System.Web.SessionState.SqlSessionStateStore.GetCo nnection(String id, =
Boolean& usePooling) +248
=
System.Web.SessionState.SqlSessionStateStore.SetAn dReleaseItemExclusive(H=
ttpContext context, String id, SessionStateStoreData item, Object =
lockId, Boolean newItem) +213
System.Web.SessionState.SessionStateModule.OnRelea seState(Object =
source, EventArgs eventArgs) +713
=
System.Web.SyncEventExecutionStep.System.Web.HttpA pplication.IExecutionSt=
ep.Execute() +167
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, =
Boolean& completedSynchronously) +117

[mahaflame]

Open enterprise manager, shut down sql server and restart it. On restart of the server ASPState db should recreate the missing objects/tables in the tempdb. If not run the create temp tables SPs in the ASPState db.

[SQLguy825]

I ran this on the db server that the site was connecting to and it solved it immediatly. No sql restart required. :)

USE [ASPState]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[CreateTempTables]

SELECT 'Return Value' = @return_value

GO