Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » sa   (RSS)
SQL Server consolidation and virtualization - hot topic in the industry
I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall Read More...
SQL Server 2005 Agent XPs disabled error - how to resolve this issue?
When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled , the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL Server Read More...
SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb
Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgradeTags posts. Here in this post I would like to go with few FAQs that Read More...
How to run Reporting Services 2000 and 2005 on the same server?
When I was installing SQL Server 2005 last weekend, one of the first things I wanted to find out was whether I could run SSRS 2000 and SSRS 2005 on the same computer. Nothing was carved on the Books Online stone for SQL 2005 or 2000 versions, but I presume Read More...
Database Diagram problems when upgraded from SQL 2000 to 2005
When you have tested the application for SQL Server 2005 comtability and upgrade process then your UPGRADE task will be easy to manage. But if you have used the Diagrams within SQL Server during the previous version, then there is a problem and here is Read More...
How to Grant ALTER TRACE in Management Studio?
In SQL Server 2005 the good feature is a SQL user can run the PROFILER or Trace without having a SYSADMIN privilege, as referred on this FAQ . Nice feature, isn't it. At the same time few users might be interested to perform same using SQL Server Management Read More...