Hello! <br /><br />Here is a post of my first thoughts of some of the new features in SQL Server Management Studio.<br /><br /><br />The query window.<br />At start I could not find how to write a query.. WHERE IS QUERY ANALYZER? <img src='/community/emoticons/emotion-5.gif' alt='' /><br />When I finally found it I thought it was pretty.. err different, and for a while I actually used Query Analyzer instead. That was mostly because I didnt know where to find all functions that I was used to use. I had problems with showing execution plan, and that sort of things. Im starting to like it more and more, and i'm sure i'll get use to it. <img src='/community/emoticons/emotion-1.gif' alt='' /> Actually there is nothing much to complain about here. I found one thing though. When I execute a SP that executes a dynamic sql with sp_executesql inside. Then I need to have "include actual execution plan" for it to be correct. If I use "display estimated execution plan", I will just get mostly useless information.<br /><br />The function/SP window.<br />I like this! The help with choosing owner, scalar/table function, help with in/out/length etc of tha parameters. It rocks! One thing though.. Why isnt it possible to sort my parameters? I want them in a certain order, but I have not found any way to do that. Any suggestions?<br /><br />The properties window.<br />This is really good.. All in one place, easy to manage and such. For example when changing properties of a user or a database.<br /><br /><br />I react about one thing though. When I start the program I always get a question about what server I want to connect to. Now since I have already registered some servers I dont want to connect to any so I have to press cancel. I wonder what is most frequent. That you register a server and use that, or that you manually enter information about the server everytime during startup. Maybe this will be fixed in a later version though.<br /><br />Overall this tool is good. Like the management of indexes. Now you can choose if your index is primary key or not. That will probably take away all the misunderstandings of pk/index. Also you can choose wheter it should be clustered or not. I like that too. I have not used all tools yet, but I can say that all tools that were before are included but they are easier to use.<br /><br /><br />Anyone more want to share their thoughts of the new tools?