Tagged: mssql
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...
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...
Howto shrink / truncate SQL transaction log file in SQL Server 2005
USE <databasename> GO DBCC SHRINKFILE(‘<logfilename-logical name>’, 1) BACKUP LOG <databasename> WITH TRUNCATE_ONLY DBCC SHRINKFILE(‘<logfilename-logical name>’, 1) GO
Microsoft SQL (MSSQL) query for active session
Howto see active sessions in a mssql. Its pretty easy just make a new query, and run sp_who or sp_who2. sp_who shows whitch active sessions there are, and sp_who2 shows more information about the...
Howto add Extended Stored Procedure xp_ndo.dll (Navision 5)
From your server computer, access the Navision Installation CD-ROM. In the folder $:\SQL_ESP, where the $ is the CD-ROM drive, click the file xp_ndo.exe. When prompted, enter the path to the BINN subfolder of...
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...
Sidste kommentar