???? ID: 311209 - ????? ???????: 04 ?????? 2010 - ??????: 2.0

TO HOW: ???????? asp.NET ??????? SQL Server ???? ?????? ?? ??????? ?? ???

???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

?? ????? ??

??? ?? ??????? ???? | ??? ?? ??????? ????

??????

?? ???? ?? Microsoft SQL Server ???? ???? ???? ????? ?? ???? asp.NET SQL ????? ??? ???? ?????? ??????? ?? ?????? ???? ?? ??? ???????? ????????? ??????? ????? ???? ??tempdb???????:. ?? ???? ??? ?? ???????? ????????? ??????, InstallPersistSqlState.sql ?? UninstallPersistSqlState.sql ??? ??? ?? ??????? ???? ?? ??? ??????? ????? ???

???:?? ???? ??? ???????? downloadable ????????? Microsoft .NET Framework 1.0 ?? ??? ????? ?? ??? ???? ??? ???? ???? ???? ????? ???? ????? ?? ????????? Microsoft .NET Framework 1.1 ?? ??? ??????? .NET Framework 1.1 ?????? ?????? ???? ????? ??? ???? .NET Framework 1.1 ?? ??? ???? ????? ?? ?? ?? .NET Framework 1.1 ?? ????? ???? ??? ????????? ?????? ??????? ????????? ?? ????? ?????


????? ?? ???? ????

??????????

  • Microsoft Windows XP, Microsoft Windows 2000 Professional, Microsoft Windows 2000 ?????, ?? Microsoft Windows 2000 ????? ?????
  • Microsoft .NET ?????
  • Microsoft ??????? ????? ?????? (IIS)
  • Microsoft SQL Server

????? ?? ???? ????

????? ?? ?????

?? ?? ??? SQL ????? ??? ???? ?????? ??????? ????????? ?????? (InstallSqlState.sql ?? UninstallSqlState.sql), ?????ASPStateTempApplications??ASPStateTempSessions???????? ??? ???? ?? ???tempdb??????? ???? ???? ?????? ???? ?? ??? ??? ???????, ???? ?????? ???? ?? ?? ??? SQL Server ??? ??? ???????? ???????? ?????

????????? (InstallPersistSqlState.sql ?? UninstallPersistSqlState.sql) persisting ????????? ??? ?? ???????? ??? ?? ?? ?????? ?? ??ASPState???? ???? ???????? ?????, ???? ???? SQL Server ??? ??? ???????? ?? ???????? ???? ?? ??? ?? ??? ?? ???

InstallPersistSqlState.sql ?? UninstallPersistSqlState.sql ??????? ??????? ????, ???????? ????? ????? self-extracting PersistSqlState.exe ??????? ?????????? ????? Microsoft ??????? ?????? ?? ??????? ?? ??? ?????? ??::
?? ??? ?? ??????? ?????? ??? ?? ??????? ????
PersistSqlState.exe ?? ??????? ???? (http://download.microsoft.com/download/asp.net/script/1/nt5xp/en-us/PersistSqlState.exe)
?????? ??????: ?????? 23, 2002

Microsoft ?????? ??????? ?? ???? ??????? ???? ?? ???? ??? ???? ????? ?? ???, ????? ???? ?????? ?? ????? ?? ???? ?? Microsoft ???????? ??? ?????::
119591  (http://support.microsoft.com/kb/119591/EN-US/ ) ?????? ?????? ?? Microsoft ?????? ??????? ???? ??????? ????
Microsoft ????? ?? ??? ?? ????? ?? ????? ?? ??? Microsoft ?? ?? ?????? ?? ?????? ???? ??????? ?????-??? ?????????? ?? ????? ???? ?? ????? ????? ?? ?? ??.. ????? ?? ?? ???????-??????????? ????? ?? ???????? ???? ??? ?? ?? ????? ??? ???? ?? ??????? ???????? ?? ????? ??? ??? ???? ??..
????? ?? ???? ????

??????? SQL ????? ??? ???? ?????? ??????? ?? ???????? ????

Persisting SQL ????? ??? ???? ?????? ??????? ???????? ???? ?? ?? InstallPersistSqlState.sql ????????? ????? ?? ????? ?? ??? ????? ????? ?? ???? ????:
  1. ??? ?? ???? ?? ????? ??? InstallSqlState.sql ???? ??? ???? ?????? SQL ????? ?? ???????? ???? ?? ???, ???? SQL Server ???? ?????? ??? ?? ??????? ?? ??? ??? UninstallSqlState.sql ????? ????? ?????? ???
  2. ??? SQL ?????? ????????, ????? ?????????????? ???????????? ??..
  3. ??????????? ????? ?????????? ????? ???, ????? ????InstallPersistSqlState.sql?? ????-????? ????, ?? ???? ????????.
  4. ????? ????,????????? ????????? ?????????????? ????????? ????? ?? ????????? ???? ?? ??? ???

????? ?? ???? ????

??????? SQL ????? ??? ???? ?????? ????????? ??????????? ?? ???????

Persisting SQL ????? ??? ???? ?????? ??????? ??????????? ?? ????? ???? ?? ?? UninstallPersistSqlState.sql ????????? ????? ?? ????? ?? ??? ????? ????? ?? ???? ????:
  1. ??? SQL ?????? ????????, ????? ?????????????? ???????????? ??..
  2. ??????????? ????? ?????????? ????? ???, ????? ????UninstallPersistSqlState.sql?? ????-????? ????, ?? ???? ????????.
  3. ???? ???? ?? ?? UninstallPersistSqlState.sql ????????? ????????? w3svc ???? ????? ?????? ??? W3svc ???? ?? ????? ?? ??? ????? ????? ?? ???? ????:
    1. ????? ????,????????? ????-????? ????, ?? ???? ????????.
    2. ??????:cmd??????????????? ???, ?? ???? ???OK.
    3. ??????? ????????? ??net stop w3svc. ???? ?? ????????? ?? w3svc ???? ???? ?? ???
  4. ??? SQL ?????? ????????, ????? ????????????? ????????? ?????????????? ????????? ????? ?? ????????? ???? ?? ??? ???
  5. ??????? ???? ???? ?? ??? w3svc ???? ?? ???????? ????? ??? ???? ?? ??? ???????? ??????? w3svc????? ????????? ???

????? ?? ???? ????

?????? ??????

  • ??? ?? ???? ??? w3svc ???? UninstallPersistSqlState.sql ????????? ?? ????????? ???? ?? ????, ???? ????? ?????? ????? ??????? ?? ???? ??:
    ??????? 'ASPState' ????? ???? ?? ???? ??????? ?? ??? ????? ??? ??
  • ??? ?? ?? ????? ??? ????????????ASPStateTempSessions?????? ??????? ???? ?? ???? ??? ???? ??????? ??? ?? ???? ?? ??? ?????? ???? ???, ????????? ???? ?? SQL ????? ????? ?? ??? ??? ?? SQL ????? ??? ????? ??????? ???????? ???????????? ?? ?????? ?? ?? ??????????? ?? ???? ???? ??? ??? SQL ????? ????? ?? ??????? ?? ??????? ???? ???

????? ?? ???? ????

??????

SQL ????? ?? ???????? asp.NET SQL ????? ??? ???? ?????? ??????? ?? ??? ??????? ????????? ????? ?? ??? ???? ???? ?? ???? ??? ???????? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
317604  (http://support.microsoft.com/kb/317604/EN-US/ ) TO HOW: ?????? ASP.NET ???? ?????? ?? ??? SQL ????? ???????? ????
?? ???? ??? ???????? ??????? ?? ?????? ???????????? ????????? ?? ???, ????? ???? ?????? ????? ???? ?? Microsoft ???????? ??? ?????:
236166  (http://support.microsoft.com/kb/236166/EN-US/ ) ????????? Re-Read ???? ?? ??? NET STOP ?? ?? IIS ?????? ??????? NET ???? ?? ????? ????
ASP.NET ?? asp.NET ?? ???? ??? ???????? ??????? ?? ??? ??????? ?????, ?????? ?? Microsoft ???????? ??? ????? ?? ??? ????? ???? ???????? ?? ????? ????:
305140  (http://support.microsoft.com/kb/305140/EN-US/ ) ?????: asp.NET Roadmap
307598  (http://support.microsoft.com/kb/307598/EN-US/ ) ?????: asp.NET ?????? ??????? ????? ???
ASP.NET ???? ?????? ??????? ?? ???? ??? ???? ??????? ?? ??? ?? ?????????? ???? ?????????? asp.NET nothin'MSDN ?? ?????:
ASP.NET ???? ??????
HTTP://msdn2.Microsoft.com/en-us/library/ms972429.aspx (http://msdn2.microsoft.com/en-us/library/ms972429.aspx)

????? ?? ???? ????
???? ???? ???? ??:
  • Microsoft ASP.NET 1.0
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
????? ?? ???? ????
??????: 
kbdownload kbhowtomaster kbstate kbmt KB311209 KbMthi
????? ?? ???? ????
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:311209  (http://support.microsoft.com/kb/311209/en-us/ )
????? ?? ???? ????