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.

December 2007 - Posts

SQL Server 2005 Reporting Services best resource for beginners
What I like within the SQL Server Reporting Services is using RDL for own formatted reports, as this gives you the complete freedom to build your own reporting designer tool, if you are not experienced in using Visual Studio based report designer or crystal Read More...
SQL Server 2005 Service Pack 2 Cumulative Update 5 is available for download with a request to CSS!
From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy Read More...
SQL Server 2005 Books Online September 2007 available for download - update your local copy
As we blogged much on Books Online importance and recent changes to availablility of updated books online for SQL Server 2005 under BOL-Sep2007-MSDN-Technet the same update is available to download. Do not forget to update your local copies as it will Read More...
SQL Server Management Studio - unable to see all the menus and unresponsive when managing SQL instances!!!
In addition to the blog post SSMS-waiting-for-an-internal-operation-to-complete I have faced additional problems such as all the menus aren't displayed within SQL Server Management Studio from the same laptop. Other users within our team has observed Read More...
SQL Server is waiting for an internal operation to complete, message on SQL Server Management Studio
Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message " Microsoft SQL Server Management Studio is waiting for Read More...
Rename a SQL Server instance, a little catch
Can I rename an instance of SQL Server after I have already installed it on the computer? Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by Read More...
MSDN labs - Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005
Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product . Similar Read More...
SQL Server Error 4616 - You cannot perform this operation for the restore database
You may be aware default 4 SQL Server system databases master, model, msdb & tempdb are created automatically when the SQL Server is installed. Those databases files can be located under default directory assuming C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data Read More...