SQL Server Management Studio « SQL Server Journey with SQL Authority

Archive for the ‘SQL Server Management Studio’ Category

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Error Messages, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on December 17, 2011 | 7 Comments »

I had very interesting and frustrating experience. Recently I was attempting to backup one of my database and I end up on following error. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘D:\Backup\SQLAuthority.bak’. Operating system error 3(The system cannot find the path specified.). Msg 3013, Level 16, State 1, Line 1 [...]

Read Full Post »

SQL SERVER – Error: Deleting Offline Database and Creating the Same Name

Posted in Database, Pinal Dave, PostADay, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on December 8, 2011 | 7 Comments »

Offline database is very interesting subject, and there are a couple of interesting details associated with it, which one must know. There are two common queries related to offline database: 1) My hard drive is getting full and I deleted my ‘offline’ databases. After deleting my offline databases, my hard drive is still full and [...]

Read Full Post »

SQL SERVER – SSMS 2012 Reset Keyboard Shortcuts to Default

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on November 5, 2011 | 2 Comments »

As a technologist, I love my laptop very much and I do not lend it to anyone as I am usually worried that my settings would be messed up when I get it back from its borrower. Honestly, I love how I have set up my laptop and I enjoy the settings and programs I [...]

Read Full Post »

SQL SERVER – Denali – Startup Parameters Easy to Configure

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on September 26, 2011 | Leave a Comment »

If you are regular reader of this blog, you must be aware that I have written about SQL Server Denali recently. I just finished a writing about various functions of Denali SQL SERVER – Denali – 14 New Functions – A Quick Guide. While working with Denali, at one point, I wanted to change the [...]

Read Full Post »

SQL SERVER – Management Studio and Browser in Same Application

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, SQL Utility, SQLServer, T SQL, Technology on May 20, 2011 | 9 Comments »

First of all – I must confess that I was not aware of this feature till I noticed it today. At home I have multiple monitors but when I am traveling I have single laptop along with me. It is often that when I am working with SQL Server I have to refer web for [...]

Read Full Post »

Older Posts »