Category Archives: Management Studio

Agent XPs Component is turned off

Cannot show requested dialog. Additional information: unable to execute requested command. ‘Agent XPs’ component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs’ by using sp_configure. In Microsoft SQL Server Management Studio i get the following errors when trying to create a [...]

How to Clear Recent SQL Server Connection List From SSMS ?

Today a junior level developer had made a human error mistake, instead of updating a record on production server, he has update the record in development server. When we did RCA for this issue, we found that this problem caused because of similar server names Production    Server Name : SRVIMUMPSQL Development Server Name : SRVIMUMDSQL [...]

When SQL Server Evaluation Edition will Expire ?

Evaluation Edition works for 180 days from the date of installation. Thus, it’s very import for me to know when it is going to stop working There are three ways to get this information, Solution 1 Open the Management Studio, click on the "Help" of Menu Bar and then on "About". In the new window [...]

SQL Server Management Studio – Client Statistics

SQL Server Client Statistics,Client Execution Time ,Query Profile Statistics ,Number of INSERT, DELETE and UPDATE statements ,Rows affected by INSERT, DELETE, or UPDATE statements ,Number of SELECT statements ,Rows returned by SELECT statements ,Number of transactions ,Network Statistics ,Number of server roundtrips ,TDS packets sent from client ,TDS packets received from server ,Bytes sent from client ,Bytes received from server,Time Statistics ,Client processing time ,Total execution time ,Wait time on server replies ,SQL Server Client Execution Time ,SQL Server Query Profile Statistics ,SQL Server Number of INSERT, DELETE and UPDATE statements ,SQL Server Rows affected by INSERT, DELETE, or UPDATE statements ,Number of SELECT statements , SQL Server Rows returned by SELECT statements , SQL Server Number of transactions , SQL Server Network Statistics , SQL Server Number of server roundtrips , SQL Server TDS packets sent from client , SQL Server TDS packets received from server , SQL Server Bytes sent from client , SQL Server Bytes received from server, SQL Server Time Statistics , SQL Server Client processing time , SQL Server Total execution time , SQL Server Wait time on server replies ,SQL Server 2005 Number of SELECT statements , SQL Server 2005 Rows returned by SELECT statements , SQL Server 2005 Number of transactions , SQL Server 2005 Network Statistics , SQL Server 2005 Number of server roundtrips , SQL Server 2005 TDS packets sent from client , SQL Server 2005 TDS packets received from server , SQL Server 2005 Bytes sent from client , SQL Server 2005 Bytes received from server, SQL Server 2005 Time Statistics , SQL Server 2005 Client processing time , SQL Server 2005 Total execution time , SQL Server 2005 Wait time on server replies ,SQL Server 2008 Number of SELECT statements , SQL Server 2008 Rows returned by SELECT statements , SQL Server 2008 Number of transactions , SQL Server 2008 Network Statistics , SQL Server 2008 Number of server roundtrips , SQL Server 2008 TDS packets sent from client , SQL Server 2008 TDS packets received from server , SQL Server 2008 Bytes sent from client , SQL Server 2008 Bytes received from server, SQL Server 2008 Time Statistics , SQL Server 2008 Client processing time , SQL Server 2008 Total execution time , SQL Server 2008 Wait time on server replies ,sql server Client Stats, sql server 2005 Client Stats, sql server 2008 Client Stats

New Features of SQL Server 2008

Here is the list of top 51 features of SQL Server 2008 which are present in SQL Server 2008 sales Boucher. My objective to cover all new features of SQL Server 2008 with detailed concept delivery with videos. Policy-Based Management Policy-Based Management is a policy-based system for managing one or more instances of SQL Server [...]

SQL Server 2008 R2 Express Edition Installation (with screenshots)

Microsoft made some important new changes in SQL Server 2008 Express R2. One of the biggest changes is that the maximum database size has been bumped up from 4GB to 10GB. But SQL Server 2008 R2 express is still limited to 1GB of RAM and a single CPU. The new SQL Server 2008 R2 Express [...]

SQL Server 2008 New Editions

Microsoft has come with two new editions  named “SQL Server 2008 R2 Datacenter” and “SQL Server 2008 R2 Parallel Data Warehouse” in SQL Server R2 release. SQL Server 2008 is already have the following editions Enterprise – For large-scale, business-critical applications Standard – For small to medium departmental applications Workgroup – For small-scale branch applications [...]