A couple of quick questions.

1. Is the account you are logged in as a local admin on both of the cluster nodes?

2. It has been a while since...

Right. I understand that. Just wondering why MS architected it that way.

Out of curiosity, why do you think it would not work OK? I too usually leave 2GB (more on larger servers) to the OS/AV/Backup. However, in your case,...

So here is a followup....

Later on in the plan, there is a CI Seek on the same table. Contained within the CI and an output of the CI seek...

Understood. The file I was expanding was a data file, not a log file.

Sorry if I was not clear on that.

It should be noted that we are telling AS to do the process in parallel and I am certain RAM is fine and we are not spilling out into temp...

I love solving my own problems! 🙂

So, the restore process I am using is wrapping some restore code up in a custom proc that allows some of our developers...

mnDBA (10/13/2010)

---

On occasion, when restoring a SQL 2005 database to a new SQL 2008 instance for testing, I get the following error:

Error: 928, Severity: 20, State: 1.

During upgrade, database raised...

I am confident it will work. I was just hoping there was a pre-existing list of what DMVs a user was...

mnDBA (10/11/2010)

---

AaronTC05 (10/11/2010)

---

Here is an example of a real world use of impersonation:

http://nickgrattan.wordpress.com/2007/07/24/bringing-impersonation-to-sql-server-2005/

For what you want to do it sounds like you'll need to grant 'permanent' (not impersonate)...

AaronTC05 (10/11/2010)

---

Here is an example of a real world use of impersonation:

http://nickgrattan.wordpress.com/2007/07/24/bringing-impersonation-to-sql-server-2005/

For what you want to do it sounds like you'll need to grant 'permanent' (not impersonate) permission...

AaronTC05 (9/22/2010)

---

Impersonate is useful when you want to give another user the same permissions for a period of time. For example, you could allow another user to impersonate...

WayneS (10/10/2010)

---

Well, you quoted my article. And that is how I fixed exactly those same issues... except I had thousands instead of hundreds.

There's only two ways to fix the problem....

Multi instance or singale instance?

You might also want to check out the SQL 2K8 licensing...

Andy Leonard (9/24/2010)

---

Hi Allen,

I don't use proxies. I've never had any luck getting them to work as I thought they should. Here's what I do instead: I...