ssms2008

Script table as CREATE includes recent column additions as ALTERs?

I'm running SQL Server Management Studio 2008 against a SQL Server 2005 back-end. SSMS just exhibited a behavior I have never seen before. I don't know if this is something new in SSMS 2008 or just a function of something else. Basically, what happened in that I added some new columns to an existing table. After adding those columns,...

Intellisense and context help for sys stored procedures - bugs or by design ?

SQL Server 2008 R2 Dev Execution in SSMS of: 1) use AdventureWorksDW; GO; sp_cdc_enable_table 'dbo', 'FactInternetSales', @role_name=NULL, @supports_net_changes=0 succeeds. Why does execution of 2) sp_cdc_enable_table 'dbo', 'FactInternetSales' --, @role_name=NULL, @suppo...

SQL Server Management Studio shortcuts in Visual Studio 2010?

I'm using Visual Studio 2010 with Team Foundation Server for my DB Project. I'v been using SSMS with VSS and gotten used to all the shortcuts. For example Ctrl + R to hide result of a query. Ctrl + T for output in text format. Also assigning custom shortcuts to system stored procedures such as sp_helptext. My Question is that, has anyo...

Importing data from SQL Server DB to another using SSMS Import/Export wizard

Hi When I'm importing data from SQL Server 2008 DB to another using SSMS 2008, I get errors during the importation because it tries to insert data in a "read only" fields, or cuz some conflicts of relationships between tables' keys. I'm wondering, how could I close the eyes of the SSMS until he finish the transformation :D Thanks, Reg...