Setting Up SQL Server 7/2000 Dependency Caching

SQL Server 7/2000 dependency caching requires you to run some setup scripts //安装脚本that build the cache tables ASP.NET will monitor for //监测changes. For this purpose the .NET Framework 2.0 provides a utility //工具called aspnet_regsql.exe.

You do not need to have SQL Server 7/2000 installed in order to follow these steps. The same scripts//脚本 and legacy //遗产dependency caching implementation //实现(next lesson) will work with SQL Express.

1.  In Windows Explorer navigate to the folder that contains the aspnet_regsql.exe command line utility//命令行工具. This will be C:\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx, where the last five digits //最后五个数字are the .NET Framework 2.0 build number. Copy the full path.

2. Navigate to Start | Run, type "cmd" and then click OK.

3. At the command prompt//提示 type//键入 "cd " and then right-click and select Paste. Press Enter<进入路径C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>.

4. Type the following, replacing "machine-name" with your machine's name or "localhost": aspnet_regsql -S "machine-name\sqlexpress" -E -d pubs -ed. Press Enter. When complete you should see the following:

5. In the same manner//样子,风格方式 execute the following command: aspnet_regsql -S "machine-name\sqlexpress" -E -d pubs -t authors -et. Press Enter.

6. Type "Exit" and then press Enter.

The authors table is ready to be monitored by ASP.NET 2.0. You will now configure//配置 your project to use dependency caching.