Answer Posted / neetika
QL Server Management Studio has the following improvements:
® In the Query Editor window, you can query multiple servers at the same time by opening query windows from registered server groups. The query results can be combined into a single results pane, or can be returned in separate results panes.
® You can access SQL Server Profiler from the Query Editor window, from the Query menu, the Query Editor toolbar, or by pressing CTRL+ALT+P.
® You can now open tables by using a Return Top n rows option.
® On the Tools/Option menu, you can specify the action that results by double-clicking tables in Object Explorer.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Can two tables have the same primary key?
What is the synonym of join?
What are relationships and mention different types of relationships in the dbms
How many triggers are possible per table?
Why do we use trigger?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Define msdb database?
What is service broker?
What is read committed?
How do indexes help, types?
What is acid properties?
What are alternate keys?
What is set nocount on and what is set nocount off?
What are the limitations in ssrs on sql server express edition?
What is a rownum?