Daily Archives: September 21, 2015

how to save website sessions to ms sql database for asp.net websites

If you are planing to use a load balancer, websites sessions may create some problems if load balancer does not support session management. In this case you can save the sessions to a ms sql database and fix the issue.¬† It’s simple to save session to database. You will need to create a database using …

Read more

change all stored procedure ownership in ms sql database

When you migrated MS SQL database to new server there is change that you may see error like “Stored Procedure not found”. Mainly this comes due to a change in dbo. Please make sure that the stored procedure is owned by the correct database user. If the user is different¬† you can correct it by …

Read more