See if a database is using Enterprise features of an Microsoft SQL server.
admin Run this command to see if any database on the SQL Server is using enterprise features
mssql
MSSQL see witch user that have SysAdmins access
WIth this command you can see witch user that have SysAdmins access.
MSSQL Databases
To show all MSSQL databases except the normal system databases.
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 If…
Shring SQL log file
USE GO ALTER DATABASE SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(, 1) ALTER DATABASE SET RECOVERY FULL WITH NO_WAIT GO Where TestDB, is the database name, and TestDB_Log is the…
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:
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…
Get SQL Collation and Version
SQL Query: SELECT @@version as 'server version' Select SERVERPROPERTY('COLLATION') as 'server collation'
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…
Ahsay restore Microsoft SQL (MSSQL) server database
If you want to restore a Microsoft SQL database, from a fuld backup, and put some transaction log file into it. (This backup has backup by ahsay) This is the…