Tag

TSQL

2 posts

How to Change SQL Server Database Collation

Step-by-step instructions for updating the collation on your ASPnix-hosted SQL Server database using the control panel. Covers existing databases, new creations, verification queries, and key considerations for maintaining data integrity and query consistency.

How to Execute aspnet_regsql on Shared SQL Server Database

The standard Microsoft aspnet_regsql tool generates scripts unsuitable for shared SQL Server due to permission requirements. ASPnix supplies a modified SQL script that works in our shared environment. Log in to your billing account to download the file, extract it, and run the script in SQL Server M