Tag
TSQL
2 posts tagged with this.
-
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