Showing posts with label SSMS 2008. Show all posts
Showing posts with label SSMS 2008. Show all posts

Friday, November 29, 2013

SQL Server Management Studio - Project

One of the features I like in sql server management studio is when the Solution Explorer got added. This is very similar to the one in Visual Studio, one of the nice things about this is the ability to keep things organised. When working with sql server Management studio and one is on a large project/being dba is to use multiple query files. Even though one maintains the files in folders, using the solution explorer can keep things organised. The solution explorer allows one to maintain the important server connections and queries all in one place. One of the options I noticed recently in SSMS is what you see in the image below: When you click on the File Menu option, at the end very of the list one can see a Move Option:

 

The Purpose of the Move option is to take your current active query file and move it one of your active projects in solution explorer. Once you choose the project the query gets added to the project in solution explorer. One of the nice things about this option is that it allows to quickly place the .sql to the project instead of going to the solution explorer and adding it. I have highlighted the query file after getting placed in the project.

 

Tuesday, June 30, 2009

SSMS-Table Changes

The other day I happened to add a column to a table using SSMS, normally i use the alter table script to do such a task. Once i added the column and tried to save the schema changes in SSMS i got an error saying Cannot save changes that require table re-creation. I digged around and found that there is an Option in SSMS to avoid such errors and enable table changes. In SSMS Under Tools -> Click On Options, a popup window appears like the one shown below. In Designers option, there is a choice for Table and Database Designers:



Under Table Options, Uncheck the box which says "Prevent Saving Changes that require table re-creation" and click the OK button.
Once this is done, this should allow table changes to be performed from SSMS, this is a new feature in SQL Server 2008.

Wednesday, May 20, 2009

New Features in SQL Server 2008...

There are Several New features in SQL Server 2008. In one of the instance I had upgraded 2005 SQL Database to SQL 2008. Then later i found out that i had to recreate the database in 2005 again. At this point i did not have SQL 2005 database backup, I was stuck for a while. Then on exploring the various tasks i found the following task which helped do my job. In the SSMS 2008, right click on the database, then click on Tasks, then click on Generate Scripts.




This will launch the Script Wizard, Choose Next, In the next screen choose the database, then choose the Choose Script Options. In this there is a option for Script for SQL Server Version, in this choose SQL Server 2005. This will generate the scripts compatible with SQL Server 2005. This would enable to create all the objects required for a SQL Server 2005 database.


There is another neat feature in this screen which the Script Data option, in case the sql server 2005 database needs to populated with Data, this can be set to true. This would enable to load a sql server 2005 database. These features came in handy when i had to go back to a SQL Server 2005 database.