Home » CodeProject (Page 19)
Category Archives: CodeProject
SSMS 2012 || Connect to Server (Additional Connection Parameters Page)
The Connect to SQL Server Management Studio presents a new Additional Connection Parameters Page. Use the Additional Connection Parameters page to add more connection parameters to the connection string. Steps to get Additional Connection Parameters page In Management Studio, on the Query menu, point to Connection, and then click Connect. In the Connect to dialog … Continue reading
SQL Server || Compress & UnComprees Backups in one Media\File
Today, We try to check of SQL server when trying to take Compress & UnCcomprees Backups in one Media\File. Query No. 1 BACKUP DATABASE DB2 TO DISK = ‘D:\DB2_FULL.BAK’ WITH COMPRESSION GO BACKUP DATABASE DB2 TO DISK = ‘D:\DB2_FULL.BAK’ WITH NOINIT Result : Run Successfully Explanation : Backup file is formatted to take compressed backup. … Continue reading
Why SQL Server Named Instance connect without specifying instance name ?
Issue : Today Evening, I was just about to leave the office and at same time I got a call from one of my friend. He is not running under any production issue but bit confused with SQL server behavior while connecting with port no. in case of named instance. He is having one named … Continue reading
How to open and view a deadlock graph .xdl file with SSMS ?
How to open and view a deadlock .xdl file with SSMS ? Solution 1 : On the File menu in SQL Server Management Studio, point to Open, and then click File. In the Open File dialog box, select your .xdl file & click open. Solution 2 : Go to the directory, you have saved your … Continue reading
SQL Server 2012 SP1 Is Now Available !
After a wait of around 8 months, Microsoft has released SQL Server 2012 SP1. Microsoft SQL Server team has released SQL Server 2012 Service Pack 1 (SP1). Both, the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. SQL Server 2012 SP1 contains fixes to issues. It includes all … Continue reading