just to confirm - I am a local admin user and also a db_owner of this database, and also within the BUILTIN\Admnistrators group - so am part of sysadmin group...

Hi Mohammed,

No I didn't use DETAIL only LIMITED (Default).

Well that is what I thought - ie re the scan density, as this sounded good, but then looking at the...

Hi

Firstly thanks for the replies.

@adam-2 - there is approx 300 or so inserts into the table, which is the only time this index would be altered. It is...

Hi Jon,

Thanks very much for your response - and I apologise for not getting back here sooner.

In any light the problem is that the application is writing to 2...

Nice easy to follow article.

I wonder if it would be possible (as I have no vb/coding experience either so going a little blind here), to monitor different instances and...

Hi David,

Funnily enough that is what I ended up doing...slightly changed the mindset of how I was going to achieve the end result - and also change the layout a...

thanks for the response Paul - although I would have expected something easier (like certain switch/parenthisis/etc around the parameter to make it aggregate etc) - sort of amazes me that something...

unbelievable!! It was NULLS!! Damn usually I am aware of these and code for them, but this time had overlooked some real basic...

opps sorry mistake while copying - the script runs without error - will update thread.

It's just the results that seem weird for some...

Thanks Phill,

Checked that with the settings above, and it wasn't listening on my new port for some reason

So I changed the "Listen All"...

And to further answer your question - we currently have SQL2000 installed along side of an instance of SQL2K5 and both appear to be running happily enough.

No problems as...

I can't run ent mgr either on my local machine (which has new 2k5 tools loaded also). am on Xp pro also...am having to use the same solution - use...

Hi Ya,

Thanks for the responses, I had been testing SQL2K5 on a seperate machine - but not a side by side scenario - sort of dumb considering  this is what...

Thanks Yelena for the response,

Our server is currently 2003std, service packed/patched and is currently running IIS and only SQL2000std. Nothing else.

Sounds as though hopefully this could be a good...

Ahhhh brilliant thanks Yelena for the clarification!