Configuring SqlCacheDependency with aspnet_regsql

Question

I am trying to prepare my database for use with SQLCacheDependency and use the aspnet_regsql utility to set up the aspnet change notification table and the corresponding triggers.

When I run the following:

aspnet_regsql -S PC199 -E -d mydatabase -ed

I get the error: 'Argument' -S 'is not valid.'

I am using SQL Server 2008 and .NET 4.

Answer 1

The -S argument must be a valid argument to identify the server hosting the database from which you want to run the command. Not quite sure, but you may need to add ".exe" to the end of the command name like this:

aspnet_regsql.exe -S localhost -E -ed -d Northwind -et -t Employees

aspnet_regsql.exe : http://msdn.microsoft.com/en-us/library/ms229862(v=vs.80).aspx