Monthly Archives: February 2006

When SQL 2005 report server web service account is changed to "LocalSystem" in C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config, report server will not be started and you will get the following error in report server log file (C:\Program Files\Microsoft SQL … Continue reading →

Connect to a sql server 2000 and run the following query, it will give right results with no errors. select ProductID,ProductName,SupplierID,CASE WHEN ProductID=1 THEN ‘P1’ WHEN ProductID=2 THEN ‘P2’ WHEN ProductID=3 THEN ‘P3’ WHEN ProductID=4 THEN ‘P4’ WHEN ProductID=5 THEN ‘P5’ WHEN ProductID=6 THEN ‘P1’ WHEN … Continue reading →

Question: How can SQL Server 2005 help me evaluate and manage indexes? (1) How can I find out whether my indexes are useful? How are they used? (2) Do I have any tables or indexes that are not used (or … Continue reading →

Three functions to check permissions in SQL 2005: Has_pers_by_name, PERMISSIONS, and fn_my_permissions. PERMISSIONS, which exists in SQL 2000, is not suggested to use becuase it will be removed in future release, use fn_my_permissions instead. SQL 2005 has a new function … Continue reading →