Tagged: mssql

0

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:

0

MSSQL see witch user that have SysAdmins access

WIth this command you can see witch user that have SysAdmins access.

  Share this:

0

MSSQL Databases

To show all MSSQL databases except the normal system databases.

  Share this:

0

MSSQL Free Space in Databases files

To get a list of the databases files, and the current disk size in MB, and the Free Space in MB in each fil, you can use this commands

Share this:

0

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

0

Username in MSSQL is not mapped to real username

After a migration of a database, the mapping of username is lost. You can rejoin the username in database security with the “real” username with this commands:

Share this:

0

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

0

Get SQL Collation and Version

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