Dear Gail,

Thanks for your ongoing help on this matter.

I have checked those

Short term

Make them a sysadmin (Cant happen , sorry)

Clear cache on a regular basis (Done this , still slow...

Gail

Thanks

So to confirm , monitoring the situtaion if it is this issue will show :-

User running query , with a high CMEMTHREAD wait time .

If so , ill check...

Ok working now , but very slow.

SA is nice and quick.

Hmm , thinking profile SA and then user and then comparing SQL profile trace

Then trying to run this code ,...

OK Gail.

Ran the command (DBCC FREESYSTEMCACHE (‘TokenAndPermUserStore’))

Which we *think* may have fixed it .

but the cahce file seems to be growing big time .

Is there a simple way to...

RG is set as default , and not been configured at all.

Thanks for the advice as well bioth of you 😀

Going to look at :-

SELECT plan_handle, ecp.memory_object_address AS CompiledPlan_MemoryObject,

...

http://www.sqlservergeeks.com/blogs/rahulsharma1975/sql-server-bi/134/finding-out-sql-server-product-code-from-windows-registry

Fair point , but in that MS article it shows you how to work around it , so havnt you answered you own question?

That mentions the same thing , using setup.exe to rebuild the master database , the same as i posted.

The link in YOUR post links to :-

How to: Install SQL Server...

Also disagree , all you need to do is follow this from MS

http://msdn.microsoft.com/en-us/library/ms143269(v=sql.90).aspx

All you need is the media to do this with , not the previous installation path...

Thats...

Have you looked at the following : it shows GUIDS

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\SqlWriter\MSIRefCount

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}

Anyone else?

Matt

All you need to do is get them up to pre-upgrade stage.

Upgrade to SQl 2008

And then get the download patches for the updates

they will be relevant to SQL 2008...

O dear

http://support.microsoft.com/kb/828339

You can access , but not manage , backward compatabilty .

Surely if you have SQL 2008 , why not install SQL 2008 management tools?

Or replace the central server management tools...

Ok good point , and it returns NULL in SQL 2008

Is this because of the security enhancments in SQL 2008 and it doesnt include the GRANT OBJECT privs?

IE:-

USE AdventureWorks2008R2;

GRANT SELECT...

I set up a user test , assigned it to Public role in SQL SMS and mapped it to the Master database.

Note , this is done on SQL 2000

Then i...