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 » anti-virus » sql server   (RSS)
Could not connect because the maximum number of '1' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed."
The above error is obvious when you have setup the SQL Server instance to accept only 1 connection. The default setting for number of user connections is '0' which accepts unlimited connections. With similar settings one of my friend have had issues and Read More...
Posted: Wednesday, September 26, 2007 3:27 AM by SQL Master | 2 Comments
Filed under: , , , , , , , ,
SQL Server 2005 Maintenance Plan not deleting old backups
If you take into account of most Frequently Asked Questions in any SQL community forums, you will get to see problems against database maintenance plans by the users. Personally I don't like them to use (by default) and professionally always depend (suggest) Read More...
Posted: Friday, September 07, 2007 1:21 AM by SQL Master | 2 Comments
Filed under: , , , , , , ,
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...
Posted: Friday, May 18, 2007 7:33 AM by SQL Master | 3 Comments
Filed under: , , , , , , , , , ,