SQL Server Management Studio
-
I recently installed the SQL Server Management Studio. I am a bit confused.
Does this also work with SQL Server 2005 database? When I run this, I do see my old database (the one that is in SQL Server 2000). I also see the new DB (AdventureWorks in SQL Server 2005). This is probably because I have a side-by-side install.
My question is this:
If I create a new table, SP, etc., does it know to create it with the right version? Will it "restrict" me with the syntax of SQL Server 2000 if I am creating in that database?
The SQL Server Management Studio looks very impressive but it doesn't seem to have good tutorials.
-
This was removed by the editor as SPAM
-
Before you can edit anything using Management Studio you must first choose which server to connect to. You either connect to a SQL Server 2000 instance or a SQL Server 2005 instance. So there is no way of editing the wrong information.
-
Got it. Thanks.
I have been playing around with it a bit and maybe I need to explore it a bit more. I could very quickly view the contents of a file in EM by right-clicking against a table. In the new one I have to right-click and then select Script Table as->Select to->New Query Editor Window and the press Execute. It seems like a bit more for doing just a simple thing.
I could also script my SPs to a file and run it against a databse (say PRD) to create/modify a SP. This also seems a bit involved.
-
With any new tool comes new ways to work ... And I see editing the table's data from the EM was something not a great thing. More often than not people have forgot simple commands
...The SSMS is surely a step closer in bridging the gap and exposing the implementation. Think, earlier if I backup a database I need to run the profiler to see what it exactly does behind the scenes. Not every operation has a "Script to" option and you get to see it for yourself.
I am not an EM person so might be a bit harsh on that comment. Anyways, I feel its fun with SSMS.
Vinod Kumar
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply