By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 2,122 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

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

P: 2
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
Apr 23 '07 #1
Share this Question
Share on Google+
2 Replies


P: 1
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.
Apr 16 '08 #2

P: 1
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
Sep 1 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.