Monthly Archives: February 2006

SQL 2005 report server and web service running account

    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

Posted in SQL server 2005 | 1 Comment

CASE level in linked server limitation

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

Posted in SQL server | 1 Comment

SQL 2005: About Index

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

Posted in SQL server 2005 | Leave a comment

SQL 2005: Partition elimination

Lubor Kollar talked about an issue SQL server 2005 has for partition elimination. http://blogs.msdn.com/sqlcat/archive/2006/02/17/Partition_Elimination_in_SQL_Server_2005.aspx   He found that The partition elimination in SQL Server 2005 does not work if there is OR between the eliminating predicates and if at least … Continue reading

Posted in SQL server 2005 | Leave a comment

TextCopy: Import file into image and text column in SQL 2000

SQL 2000 has a undocumented command prompt tool TextCopy, which can load a file into a text or image column. The tool usesDB-Library connectivity. The tool is under \Microsoft SQL Server\MSSQL\Binn. Goto the folder in command prompt, type TextCopy -?You … Continue reading

Posted in SQL server | Leave a comment

SQL 2005: Check permissions on a securable

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

Posted in SQL server 2005 | 2 Comments