If I want to save any changes in a table, previously saved in SQL Server Management Studio (no data in table present) I get an error message: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that … Read more
In Visual Studio & other IDEs, you can easily auto format your code with a keyboard shortcut, through the menu, or automatically as you type. I was wondering if there is yet a way to enable this standard feature in SQL Server Management Studio? I’m working with some large-ish stored procs that are a mangled … Read more
I am attempting to create a Stored Procedure for a newly created database. However the SSMS intellisense does not recognize more than half of the tables which have been created. For example whilst in the left hand column under tables I have a table dbo.Room, when I type “dbo.” in the new query window, that … Read more
SQL Server Management Studio always inserts a GO command when I create a query using the right click “Script As” menu. Why? What does GO actually do? 9 Answers 9
I am trying to connect to a Microsoft SQL 2005 server which is not on port 1433. How do I indicate a different port number when connecting to the server using SQL Management Studio? 6 Answers 6
We are writing a new application, and while testing, we will need a bunch of dummy data. I’ve added that data by using MS Access to dump excel files into the relevant tables. Every so often, we want to “refresh” the relevant tables, which means dropping them all, re-creating them, and running a saved MS … Read more
When I create a table in SQL Server and save it, if I try to edit the table design, like change a column type from int to real, I get this error: Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made … Read more
