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:
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:
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…
SQL Query: SELECT @@version as 'server version' Select SERVERPROPERTY('COLLATION') as 'server collation'
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…
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…
Start SQL Server Management Studio Connect to you SQL server instance Start a “New Query” And then put this into you SQLQuery1.sql window sp_configure ‘show advanced options’,1 reconfigure with override…
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…
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…
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,…