April 23, 2008 at 4:01 pm
I know how to do it in 2000 by running the InstallSqlState.sql statement in 2000's query analyzer, but if I run that in 2005 new query window, it errors out. Please help. Thanks
April 24, 2008 at 12:37 pm
what ever do you get ?
April 24, 2008 at 12:41 pm
April 24, 2008 at 1:30 pm
I get this below.
In SSMS, I opened installsqlstate.sql and executed this file and got this. Thanks
-----------------------------------------
Starting execution of InstallSqlState.SQL
-----------------------------------------
--------------------------------------------------
Note:
Do not run this file manually.
You should use aspnet_regsql.exe to install
and uninstall SQL session state.
Run 'aspnet_regsql.exe -?' for details.
--------------------------------------------------
If the job does not exist, an error from msdb.dbo.sp_delete_job is expected.
If the category already exists, an error from msdb.dbo.sp_add_category is expected.
Msg 14261, Level 16, State 1, Procedure sp_add_category, Line 32
The specified @name ('[Uncategorized (Local)]') already exists.
------------------------------------------
Completed execution of InstallSqlState.SQL
------------------------------------------
April 24, 2008 at 1:41 pm
nevermind, I ran aspnet_regsql and through the wizard and selected by instance and aspstate database and it created the tables for it. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply