How do I create the ASP State Database in SQL 2005?

• OklahomaSooners

  Old Hand

  Points: 334

  More actions

  April 23, 2008 at 4:01 pm

  #189413

  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

• Frances L

  SSCarpal Tunnel

  Points: 4727

  More actions

  April 24, 2008 at 12:37 pm

  #806819

  what ever do you get ?

• bledu

  SSChampion

  Points: 12335

  More actions

  April 24, 2008 at 12:41 pm

  #806823

  yes, whatever do you get?

  ---

  Everything you can imagine is real.
  

• OklahomaSooners

  Old Hand

  Points: 334

  More actions

  April 24, 2008 at 1:30 pm

  #806856

  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

  ------------------------------------------

• OklahomaSooners

  Old Hand

  Points: 334

  More actions

  April 24, 2008 at 1:41 pm

  #806862

  nevermind, I ran aspnet_regsql and through the wizard and selected by instance and aspstate database and it created the tables for it. Thanks.