SQL Server 2005 Management Studio tips

February 14, 2009 01:00 by pradeep.mishra

Tip # 1

Problem:  You have too many connections stored in your management studio using IP address. Sometime it is hard to remember the IP address vs server mapping. Or you have scripts to run on various servers in same management studio instance.

Solution: Use SQL Server Connection Registration feature as shown in diagram below and you can organize all your connections in amazing ways. To get this window just go to View -> Registered Servers.

 

 

Tip # 2

Problem: You are trying to get the things done using SQL Server designer because you don’t remember the query syntax. E.g. Adding a new column, insert script etc

Solution: SQL Server Studio has a feature called Template Explorer(Hit CTRl+Alt+T) and you can see readymade queries available for most of the day to day operation. You can even create your own templates. See the diagram below

 

 

 

Hope this will help you in someway.

kick it on DotNetKicks.com

Currently rated 3.3 by 6 people

  • Currently 3.333333/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Comments