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
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Define compound operators?
Explain the phases a transaction has to undergo?
Is null in sql server?
Define outer join in sql server joins?
What is the largest component inside a field?
Why use view instead of a table?
What is difference between rownum and row_number?
How to write a query with an inner join in ms sql server?
What is dirty read?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Why use cursor in sql server?
How do I find the sql server database version?
Explain the concept of view and Types of views in SQL server?
What is unpivot?