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

[athishay1]

Invalid object name = 'tempdb.dbo.ASP StateTempApplic ations'.
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.ASP StateTempApplic ations'.]
System.Data.Sql Client.SqlConne ction.OnError(S qlException exception, =
Boolean breakConnection ) +95
System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion =
exception, Boolean breakConnection ) +82
=
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateOb=
ject stateObj) +346
System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior, =
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleR esultSet =
bulkCopyHandler , TdsParserStateO bject stateObj) +3244
System.Data.Sql Client.SqlComma nd.FinishExecut eReader(SqlData Reader =
ds, RunBehavior runBehavior, String resetOptionsStr ing) +186
System.Data.Sql Client.SqlComma nd.RunExecuteRe aderTds(Command Behavior =
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean =
async) +1121
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior =
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String =
method, DbAsyncResult result) +334
=
System.Data.Sql Client.SqlComma nd.InternalExec uteNonQuery(DbA syncResult =
result, String methodName, Boolean sendToPipe) +407
System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +149
System.Web.Sess ionState.SqlPar titionInfo.Init SqlInfo(SqlConn ection =
sqlConnection) +379
System.Web.Sess ionState.SqlSta teConnection..c tor(SqlPartitio nInfo =
sqlPartitionInf o) +545
System.Web.Sess ionState.SqlSes sionStateStore. GetConnection(S tring id, =
Boolean& usePooling) +248
=
System.Web.Sess ionState.SqlSes sionStateStore. SetAndReleaseIt emExclusive(H=
ttpContext context, String id, SessionStateSto reData item, Object =
lockId, Boolean newItem) +213
System.Web.Sess ionState.Sessio nStateModule.On ReleaseState(Ob ject =
source, EventArgs eventArgs) +713
=
System.Web.Sync EventExecutionS tep.System.Web. HttpApplication .IExecutionSt=
ep.Execute() +167
System.Web.Http Application.Exe cuteStep(IExecu tionStep step, =
Boolean& completedSynchr onously) +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].[CreateTempTable s]

SELECT 'Return Value' = @return_value

GO