alcohol and cialis sleepwell double bed gadda price where to get lasix for dogs can u buy valtrex over the counter in canada byu celebrex lawsuit

Tagged: sql


See if a database is using Enterprise features of an Microsoft SQL server.

Run this command to see if any database on the SQL Server is using enterprise features

  Share this:


Shring SQL log file

USE [TestDb] GO ALTER DATABASE [TestDb] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE([TestDb_Log], 1) ALTER DATABASE [TestDb] SET RECOVERY FULL WITH NO_WAIT GO   Where TestDB, is the database name, and TestDB_Log is the SQL Log file name....


Citrix XenApp failed to connect to Data Store

Today i have this problems on one of the Citrix XenApp servers, that the service IMA won’t connect to the Data store. It failed with this events: 1. Citrix XenApp failed to connect to...


Change SQL Collation

Steps for chaning Collation: Take backup of Databases and logins. Detach all databases execpt system databases. (All users databases) Find the SQL server installation path (Root of the CD) Run this command: Setup /QUIET...


Get SQL Collation and Version

SQL Query: SELECT @@version as ‘server version’ Select SERVERPROPERTY(‘COLLATION’) as ‘server collation’ Share this:


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...