Category: MSSQL

0

Username in MSSQL is not mapped to real username

After a migration of a database, the mapping of username is lost. You can rejoin the username in database security with the “real” username with this commands:

0

Change SQL Collation

Steps for chaning Collation: Take backup of Databases and logins. Detach all databases execpt system databases. (All users databases) Find the SQL server installation path (Root of the CD) Run this command: Setup /QUIET...

0

Get SQL Collation and Version

SQL Query: SELECT @@version as ‘server version’ Select SERVERPROPERTY(‘COLLATION’) as ‘server collation’

0

Limit SQL Server maximum memory SQL instance

Start SQL Server Management Studio Connect to you SQL server instance Start a “New Query” And then put this into you SQLQuery1.sql window sp_configure ‘show advanced options’,1 reconfigure with override go sp_configure ‘max server...

0

Limit SQL Server maximum memory SQL of WSUS

Start SQL Server Management Studio Connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query Start a “New Query” And then put this into you SQLQuery1.sql window sp_configure ‘show advanced options’,1 reconfigure with override go sp_configure ‘max server memory’, 256 reconfigure...