Thanks Marcus, I missed that! Thankyou

For SQL Server 2005, I normally allocate at least 10Gb on C drive. Even though you configure all the components to use another drive, the system drive requires roughly above...

Sneha - did u try running the exe directly? If this is not working fine, you can probably reinstall the tools (remember, only tools) for the instance, by the setup...

did you try Try...Catch?

but there you cant change the "> 0" to any other value, say "> 5". Or, is the PageId value not an issue?

Sneha - you got it?

please check BOL for the same

try the following -

select Id, Status, PageId from YourTable

order by case when PageId > 0 then Status End

http://rajanjohn.blogspot.com

if you havent got the "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" existing, you would have probably missed installing it. To install, run the SQL SErver 2005 setup again, and add components,...

It is better you go and look into BOL for such things. If you dont have BOL installed, look into following msdn links - http://msdn2.microsoft.com/en-us/library/ms179316.aspx

http://msdn2.microsoft.com/en-us/library/ms189563.aspx

http://rajanjohn.blogspot.com/

Did u try "ServerName\InstanceName , PortNumber"?

I dont agree with looking too much into the questions, and ofcourse rubbishing the editor (thats being thankless). The purpose of the QOD would be to trigger thoughts! If the...

run BIDS from Start --? Microsoft SQL Server 2005 --> SQL Server Business Intelligence Development Studio. The exe is dropped at "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" in my default installation....

run select @@version; you should get 3042 if sp2 is installed

clr integration can be enabled from sp_configure. But, there are lot of security considerations both you and the developer to do before starting the coding. The developer should think about...