When you open the SQL Server Management Studio and you are writing new queries the drop down lists of the database resets back to its default. Then you'll have to remember to change it or write "USE ..." in the SQL statement everytime. This can get frustrating.
To change the default database follow these steps below:
Step 1 - In Object Explorer expand Security folder. Expand Logins folder and look for your Username.
Step 2 - Right click on your User and select Properties
Step 3 - In the Login Properties look for "Default Database," choose the database and press the "Ok" button.
That's it! :D
Have you ever wondered what those icons are on the top right of the toolbar? Don’t be afraid. Go ahead and click and see what happens.
These icon’s are very helpful. For instance if you accidentally closed out “Solution Explorer” one of these icons can help you open it back up. To find out which one, point your cursor on top of the icon’s and wait a second. A help dialogue box pops up that states what the icon is. Plus it will give you short cut keys.
Pretty cool, huh? After experimenting with the icons, now you can layout your custom workspace to maximize the efficiency of development work.
Tags: Visual Studio 2010, Tips
Software Development | Exsilio Homepage
Powered by Exsilio Solutions