Valuable Learnings

I have been facing a severe issue when i try to install SQL Server 2005. SQL Reporting server is already installed in my system and I need to un-install that first and Install SQL Server again. When I try to un-install Reporting server i got this error: The setup failed to read IIsMimeMap table. The error code is -2147023550. I spent a day to resolve this issue and finally i found a link to do the same. IIS Admin service is the culprit, which needs to be stopped before un-installing the Reporting server. If you face the same issue, plz follow the steps. 1) Stop IIS Admin Service 2) Stop IIS 3) Uninstall SQL Server Reporting services. These steps will work like charm and thanks to friend , who helped me in this regard.

How to send the sort expression as a parameter to Stored Procedure? This is the problem that I faced in one of my recent tasks. When I was given this work, without much thought, started with the following lines. CREATE PROCEDURE GetProcedure @ sortExp varchar(25) AS select ProcedureID,Items,[Value] from Procedure order by @sortExp DESC When I tried to run this stored procedure, I got an unexpected error saying, Msg 1008, Level 16, State 1, Procedure GetProcedure, Line 5 The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name. Then, I started to think about the error and soon I traced the fault. The problem is that- SQL Server is not recognizing the given parameter as a table column. By default all the parameters are considered to be of some data type. They can't be converted into type 'Column'. As " Order by"...