It's post two years ago, not sure anyone else has this issue recently? I experienced this error couple of days ago but I can't find any proper answer.

I have two...

don't know hwo to delete it ...

Thanks for ur reply.

I have tried to execute this command : exec sp_dropuser [domain\groupname] in SSMS directly, but still failed. Please note what i wanted to drop was domain group,...

I used another way to run DROP USER successfully in script, see below. But still don't know why sp_dropuser cannot be used to delete this kind of users.

DECLARE @UserName sysname;

DECLARE...

Jacob Wilkins (2/27/2014)

---

Another important thing to note is that the max_cpu_percent very, very rarely actually limits anything to that percentage. In SQL Server 2012 they introduced the additional cap_cpu_percent, which...

sqlbuddy123 (2/27/2014)

---

I think it's not like it works only on Win 2008 R2. May be they didn't test it on other OS.

It works for me on Win 7 and...

Yes I did. Can you tell me your OS version, SQL version and CPU information? Thanks

it seems can run on Windows Server 2008 R2 only.

Unlucky I got the error message same as the...

Thanks for your help, I am trying the tool in the link ... let you know later.

sqlbuddy123 (2/27/2014)

---

LowPriorityPool should not be 25% CPU as the Max was 20%. May be the classifier function is not working properly and

the requests are getting redirected to the default workload...

any suggestion? thx

sqlnaive (2/11/2014)

---

I'm facing an issue here. I have one procedure which inserts data in a table with the help of some joins in few tables. Now there are around 1000...

use sp_grantlogin to create windows users or groups:

sp_grantlogin @loginame = 'domain\users or groups'

in SQL2000, you need using sp_grantlogin to add windows users or groups

http://technet.microsoft.com/en-us/library/aa933411(v=sql.80).aspx

make sure your third node has enought resource like memory to take over the new instance.

You mentioned 'After a while, it will fail back to other nodes ...' I think...