Sql Caching in asp.net

Posted: February 8, 2010 in asp.net

VS command prompt

>aspnet_regsql -S streamline -U gamepoint1979 -P gamepoint1979 ed -d gamepoint2

>aspnet_regsql -S streamline -U gamepoint1979 -P gamepoint1979 -d gamepoint2 -et -t Teams

>aspnet_regsql -S streamline -U gamepoint1979 -P gamepoint1979 -d gamepoint2 -et -t MatchSetups

>aspnet_regsql -S streamline -U gamepoint1979 -P gamepoint1979 -d gamepoint2 -et -t MatchResults

WebConfig

Change the name of database from Gamepoint2 to the new database

Change the ‘connectionStringName‘ from Local to the connection being used

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s