Welcome to SSQA.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 » ssrs   (RSS)
Reporting Services setup in Vista, simple resolution
Recently on our Development platform we have deployed the Vista operating system to test an application against this installation. Part of the project is to deploy reports for the users using reporting services components, I was able to fix the issues Read More...
Anti-virus tool on SQL Server
Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server Read More...
Management Studio shortcut keys
Having a shortcut feature for a tool is handy to work quicker than clicking with a mouse on a PC, I always use Keyboard more than mouse and only when I feel lazy or not keen on the subject then will use mouse. As per the SQL Server 2000 Books Online I Read More...
Credentials used to run this report are not stored
In Reporting Services there is a feature to Cache a temporary copy of the report that can be used to paste elsewhere. If the proper username has not been granted on Report Manager the user will get error "Credentials used to run this report are not stored". Read More...
Use Import/Export wizard with SQLExpress edition
You may be aware about SQL Server 2005 Express edition is a free and simple to manage edition in 2005 version. It has an integratin with Visual Studio 2005 to make it easier to develop data driven applications with a redistributable option, well I'm not Read More...
SQL Server 2005 - bunch of SSIS issues
There has been lot of issues with SSIS packages since the release of SQL Server 2005 and few of them were corrected in Service pack releases. Still there are few existing on SQL 2005 editions creating issues when a script task or a script component that 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 do I...?
As a SQL Server user have you ever looked at 'How do I....' topics in Books online? I'm afraid not many will be interested to look at it, I know if you are an expert in SQL Server then visitng BOL will be quicker for you to look for what you need. For Read More...
SQL Server Clustering resources and help
Whenever I have a problem with Cluster based issue on my SQL arena I will always refer to one resource which is Brad Clustering Resources . As you may know Brad McGeehee is a SQL Server MVP and Industry specialist, founder of SSP site that helps lot of Read More...
Unable to modify DTS package in SQL Server Management Studio
One of the developer in our team gave me a call to seek help on the issue they are facing, they are unable to modify or open the DTS package in SQL Server Management Studio. The Server they are working is SQL 2000 version and due to the mixture of 2005 Read More...
Install SQL Mobile edition on the top of SQL 2005 client tools?
I too have had problems installing the recent service pack of Visual Studio (VS) that includes the recent SQL Server Compact Edition (SQLCe) binaries. Before this problem you have to ensure and check whether you've installed any CTPs they must be uninstalled Read More...
Create folders under a project using Visual Studio aka BIDS
Using BIDS any user cannot create folders under the project like VS2005 does. As usual u ser can create more than one query folder, and the root folder can create child folders. The only way to recover this problem is to edit the XML file that is created Read More...