Hi,

I am also encountering the same issue, could you please let me know it got solved.

I see the DLL in the BINN folder, I also the see the other dlls you mentioned in the system folder.

When I try to register the odsole70.dll now using...

All the Raiserror statements inside the stored procedures are for informational messages and their severity is set to 0. So they are not getting caught inside the TRY....CATCH block.

Thanks All, The solutions are working fine. Thanks for your inputs.

Do we have an option incase if we are not scheduling them in SQL job ? I mean if we...

Thanks,

The scenario is, I have thousands of stored procedure which have been written with raiserror already. All these days we were having the front end (C++) handling this logging into...

Yes both are 2008 servers

Hi, Thanks all. I thought to re-write that piece of code with suggestion given in this forum. Now I face another issue with the joins, my code looks like,

update table1...

both instances match the records

Version : sql server 2000 sp 2

primary key is there. so it has created clustered index. Rebuild doesnt give any improvement.

The actual table has an id, name and its description. id is the primary key.

The description is huge which has length ranging from 3000 to 5000 characters.

I use simply query...

Independent on the environment, can we make this query run faster by anyway ??

Our ultimate aim is to run the query faster. Is the performance lack due to the huge...

The same case is with the QA environment also ? which wont have difference in load when compared with development.

Hi Madi,

The output wont be the one I expected. The decimal should not get truncated.

The query has ROW_NUMBER function and I am getting only rows with certain range like 50 to 100 which will be passed through variable using CTE.

The same query if use...

Hi Andras, Its a good idea.Thank You Very much.

Regards,

Aravind