I acutally ended up rewriting the query and its much faster. Dynamic SQl was much faster but coz of SQL injection attack, eneded of rewritng the query. Lowell, thanks for...

I mean we get alert when the job fails. Anybody has seen that before? In this case, one of the step in the pkg failed but job succeeded. So, it...

Added that index. But no significant improvement. So, database setting Auto Statisctics Update to False, doesn't impact anything?

Hi, I have attached the exec plan. I also noticed database setting is set to Auotupdate Statistics to False. Not sure if this needs to set to true.

Thanks for your...

Thanks. But SSMS returns fine within 3 secs on both servers. The problem ion one of the server is when .NET app calls it. All the indexes as suggested by...

One thing I didn't understand is, if sp returns fine on one server, why would it need a revison on another server?

Another clue. SP makes use of a table variable. Does changing it to temp table will help? The same sp on another server returns data to the app within few...

Yes..DataAdapter. Using command object.

Just calls the sp and shows that results to the grid.

What would be the solution? Really it just returns 72 rows.

When I uninstall 2005, all the db files will be in their folder, correct? They don't get wiped out, correct? Because I want to be able to attach those db...

Yes. That one worked. Thanks!

When I uninstall 2005, all the db files will be in their folder. correct? Because I want to be able to attach those db files after I install 2008.

Thanks. I will use the working query. Thanks for all of your help.

Thanks. I found on the MS site sp_helprevlogin stored proc that could script out the logins.

As far as Jobs, I can right click and script those out. But doing so,...