September 2007 - Posts
SQL Server User Education blog on MSDN has this update about SQL Server 2000 BOL Update - Don't forget to update your local version copy with this latest release. You can download the updated SQL Server 2000 Books Online from the Microsoft Download Center.
Read More...
SQL Server version 2005 Books Online aka BOL has been updated by SQL Development Team in September 2007 and not available for download yet. As usual they are awaiting customer feedback from the BOL or via MSDN/Technet pages. Refer in their words: In the
Read More...
Well this is confusing me, this DownloadLink refers SQL Server 2005 Books Online as May 2007 update that can be installed on the machine. But when you search for any content on MSDN library for SQL Server it refers " SQL Server 2005 Books Online (September
Read More...
Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,
Read More...
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...
So who installed the SQL Server, how can you find it? This was the question asked by an user when I was sitting in SQLPASS SQL Lounge to help the users. The question was obvious and interesting to answer. Until SQL Server version 2000 you could refer
Read More...
On one of the SQL Server instance recently we have been getting the following error: SQL Server could not spawn FRunCM thread. Error: 17182, Severity: 16, State: 1. 2005-10-30 15:35:44.79 Server TDSSNIClient initialization failed with error 0xd, status
Read More...
Got a distressed call from one of the database operators stating the error on the subject, instantly I suspect that the hardware of that server is not doing well. As the error ""Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>'
Read More...
Paul Randal has highlighted the importance of DBCC statements you execute within your SQL environment and care you need to take care when you get a solution for your question on the forums & newsgroups. Best advice is to test whatever has been specified
Read More...
While installing SQL Server Express 2005 you might have come across the error: System Configuration Checker Fails with "Performance Monitor Counter Check Failed" Message As you have seen that one of the README file for SQL 2005 installation suggests the
Read More...
One of our client had such requirement to cater a load balancing for their application and needed to upgrade to higher versions of SQL Server & Operating systems. The current setup at their end is a SQL Server 2000 Active/Passive Cluster and the transactions
Read More...
Interesting newbie question on the forums to share. I am selecting a value from a table(column).I do not want any 2 users can select same value at the same time..in other word 1 value only be selected by individual user. in order to do it I am simply
Read More...
Here is another common error you will get to see with Database Maintenance plan in SQL Server 2005, though most of it has been resolved with Service Pack 2 and hotfix but still you need to take care few things. Error: Value of 'DD/MM/YYYYHH:MM:SS' is
Read More...
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...
You can use the Report Manager by following these steps: Go to the folder in Report Manager where you have the report and click the Show Details button in the upper right. Click the Edit icon next to the report you want to share, and then click the Security
Read More...
Performance tuning exercise involves using SYSMON for the server based tasks, also I have seen users referring that MEMORY is at peak level by referring to Task Manager on the server. Not always depend upon the task manager, for optimum information better
Read More...
If you have been using the database diagrams from SQL Server 2000 onwards and when it is upgraded to SQL 2005 you might get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects
Read More...
When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when
Read More...
You may be aware the DML and DDL triggers can be nested up to 32 levels, because any reference to such trigger code counts as one-level in the nesting limit. Even though it is possible to control whether AFTER triggers can be nested through the nested
Read More...