Hi Nimesh,

this is quite old post and I hope you managed to upgrade this. I am also planning to do the same upgrade but with SQL 2012.

Can I ask...

thanks for quick reply. Answers to your questions are:

I never done this before.

It will be in-place (upgrade existing system)

its is SP4

This should worth of 100 points 🙂

Hi David,

Have you checked to run this sp using sqlcmd ?

I faced same problem long ago. it was not a buffer cache issue. Please let me know using sqlcmd

Thanks,

Muhammad

Hi foxxo

Nice TIP.

Any idea Why this improve performance ??

Agree with Christian Buettner ... IN is the operator used in the predicate.

You can find all information here

http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

-Muhammad

Hello,

Yes if you will go for 2005 then you need to upgrade to 2008. It all depends on your job role whether you are development DBA or Production DBA.

For SQL...

Hi Niyala,

do u get any SQL Server Edition Operation System Compatibility warning during System Configuration Check screen ?

ohh i got it,

i mistyped sp_executeSQL

Thanks a lot for this , i works now

Again Thanks a lot,

Now after turning RPC and RPC out to True, getting this error

Procedure expects parameter '@handle' of type int.

My statement looks like this.

exec [A].[master].[dbo].sp_execute N'Select @@cpu_busy'

Hi Baddabing,

Thank you very much for your reply, i get this error

Server 'A' is not configured for RPC.

i tried to change this RPC value to true from linked server...

HI GURSEThi,

Thank you very much for your reply. The interesting thing is that if you right click and go to prpperties-----Files, Even if it tells InitialSize (MB), but in actual...

i did this a couple of times, but in vain

Hi,

Another simple way to do this 🙂

1)- write click on level 2 text box (if you want have 2 levels)

2)- Click Edit Group

3- Go to the Visibility tab

4)- Select...