MSSQL see online user
admin Just run this in a SQL query: SELECT SYSTEM_USER
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…
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…
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…
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…
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,…