it may be a problem with the surface config - I seem to remember I had to allow something to enable maint plans - probably the SSIS service ?

seen this question posted several times ( prob not from same person ) The answer is no and my answer is always the same - welcome to DSS Hell!

Largely the...

We perhaps need to be precise about what we are talking about:- a dbcc dbreindex with the table passed will not only rebuild all the indexes but will also update...

The symptons you describe don't really match the conclusions. How do you establish that your procedure cache is being cleared ? Are you using a maint plan for your backups...

There are a number of subtle differences between the editions - the one that usually most interests me is the options that multi-thread , e.g. index rebuilds, dbcc , on-line...

I wasn't aware the keep plan option resolved recompiles with temp tables. If the dataset is small I suggest you use a table variable.

OK so it's long post and I'm not too sure what is actually causing the problem for you.

If you rebuild indexes and/or stats then you will get blocking on your...

I for one would be pleased to remove the ability to do some of the changes through SSMS, I trust you never "fiddle" in a production environment.

However, it does seem...

BOL would be a good place to start! Procedures are run with the execute command e.g.

exec dbo.myproc

That's a strange one to be sure, I can't reproduce it - you've not changed any settings or permissions? - my installs are out of the box - I connect...

not tried but I'd suspect it won't work - you could try an attach and detach

I'd really advise you to recollate your databases to the windows collation, however, the collation setting is on the collations settings install page - choose a sql collation rather than...

Hah .. my moaning about lack of security has sparked an interest in security so your posting has come just at the right time!!

If we get to do this and...

Assuming your drives are all part of the cluster resource group there is no difference moving files around a cluster as you would a stand alone server.

sorry being too vague ( again )  .. yes I intended to say that restoring a filegroup without the other filegroup backups I don't think is allowed in sql 2000...