ALZDBA (10/14/2010)

---

- can you repro the situation ? (DDL ?)

- can you post the actual tsql you tried ?

(and their results)

- what's the relation between the service account and...

This looks equivalent to what I did through SSMS, but I'm still not sure why the service account was not as good as...

OK, I fixed it, but I don't understand how... :hehe:

In SSMS I right-clicked on the database, chose Properties, clicked on Files tab, and changed Owner to sa (it was...

Here is something odd:

in the said database, under Security/Users, I right-click on the database user "dbo", select "Properties: the User name is "dbo", but the Login name is the...

When I right-click on the database, select Properties, in the General page the owner is the SQL service account and not the login I am trying to unmap. (I'm on...

I think your idea has a lot of merit. I'm actually also planning to do something similar, if for no other reason than to get a feel of doing things...

You may have already seen this link, but here it is; it describes an alternative way to what you are trying to do, and complications that come with it:

http://www.eggheadcafe.com/software/aspnet/30323724/how-can-i-see-what-permissions-view-server-state-has.aspx

reggie burns-317942 (10/11/2010)

---

Thanks for all the input.

After running update statics on 5 of the must active tables the queries are running much better, as if it was still in...

See "SQL Server 2008 Upgrade Technical Reference Guide":

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

Here are the steps:

1. Change db compatibility level to 100 on all upgraded databases

2.(ONLY...

I sent it to all developers on my workplace, and after that no one was talking to me that day...

I loved it! 😀

Hmm, it may not be too surprising that I cannot upgrade from SQL 2008 R2 to SQL 2008 SP2.

SQL 2008 R2 is probably on a different version stream, so it...

48 GB.

I know, I can't explain what...

Now I'm getting following error;

can I not upgrade from SQL 2008 R2 to SQL 2008 SP2?

There are no SQL Server instances or shared features that can be updated on...

After restarting, I can get past that point, so it seems it was an issue with memory resources on the server...

It looks like I ran out of memory while applying the SP (!), so setup assumed there was an actual problem with the server configuration;

I have restarted the server and...