SQL Query:
SELECT @@version as 'server version'
Select SERVERPROPERTY('COLLATION') as 'server collation'
Tag Archives: sql
Backup msSQL server – Operating system error 5(error not found).
If you want to take a backup from Microsoft SQL Server management Studio, and get this error: Operating system error 5(error not found), then the problems is that the user running SQL Server services dosen’t have access to the destanation folder of you backup.
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.
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 users.
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.