Querry Optimization

Question

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738663 More actions · Answer 1

Never seen this. Have you changed any settings? Is there an SP appplied?

I checked my errorlogs and this isn't in them.

Steve Jones

Andy Warren SSC Guru Points: 119902 More actions · Answer 2

Are you running the personal edition? Or MSDE? I saw a couple newsgroup postings that indicated this is the probable cause of the problem.

Andy

sthatikonda Valued Member Points: 52 More actions · Answer 3

Yes. We have applied SP2. We didn't change any settings. How can I check, the server is configured for, number of querries.

I tried with sp_configure, but is not showing about querris configuration.

sthatikonda Valued Member Points: 52 More actions · Answer 4

Valued Member

Points: 52

December 11, 2001 at 3:03 pm

It is Enterprise Edition.

Satya

Andy Warren SSC Guru Points: 119902 More actions · Answer 5

Could you run select @@version and post just to be sure?

Andy

sthatikonda Valued Member Points: 52 More actions · Answer 6

I am sorry it is Personal Edition.

Thanks,

Satya