Tag Archives: sql

Change SQL Collation

Steps for chaning Collation:

  1. Take backup of Databases and logins.
  2. Detach all databases execpt system databases. (All users databases)
  3. Find the SQL server installation path (Root of the CD)
  4. Run this command:
    Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLServer /SAPWD=Qwerty123 /SQLSYSADMINACCOUNTS=”administrator” /SQLCollation=SQL_Scandinavian_Cp850_CS_AS

/QUIET – Run it as a sillent installation

/action – We are running rebuilddatabase to change the server collation

/Instancename – withs instance do you want to change collation on.

/SAPPW -SA password for this instance

/SQLSYSADMINACCOUNTS – An administration account, normally the run you are running this from. The user should be administrator of the SQL Server

/SQLCollation – withs collation should you change to.

 

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 with override
go

  • Then push the execute buttom, this will limit you SQL of WSUS to 256MB, whitch should be enough.

Install SQL Express 2005 quiet and with DISABLENETWORKPROTOCOLS=0

First you need to download SQL Express 2005 setup files, there can be done from microsoft homepage.

Then when you have download the setup files, you need to extract it, it can be done by typing:
SQLEXPR.EXE -x

It then ask you a location to put the extract files.

Then you can run this

SETUP.EXE /qb ADDLOCAL=SQL_Engine,SQL_Data_Files INSTANCENAME=”dalbjerg” SECURITYMODE=SQL SAPWD=”SAPassword” DISABLENETWORKPROTOCOLS=0

This will install the database name dalbjerg, and with sa password SAPassword.