Just run this in a SQL query:
SELECT SYSTEM_USER
Just run this in a SQL query:
SELECT SYSTEM_USER
sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, 4096
reconfigure with override
go
sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, 256
reconfigure with override
go
USE <databasename>
GO
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
BACKUP LOG <databasename> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
GO
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 users.
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 the SQL Server installation folder. (The unzipped xp_ndo.dll file must be in this folder on SQL Server.)
(Standard msSQL 2005 is: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn)
Open Microsoft SQL Server management Studio Express, connect to you database server.
Navigate to SQLServer -> Databases -> System Databases -> Master -> Programmabilty
Right click on Extended Stored Procesdures, and chose ”New Extended Stored Procedures”
Chose the XP_ndo.dll files.
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.