Are you getting an error? If so, what error. If not, what is the result you are getting, and what are you actually looking for?

Steve Jones - Editor (12/19/2008)

---

We can argue about whether an indexed view should be a type of index or not, but right now MS is choosing to call it that....

Is there a way to run the service pack install from the command line and have it update only a specified instance, either the default or a named instance?

I'm wondering...

But if you read the documentation, SQL Server will use the index on an indexed view when querying the base table if it the optimizer determines that it would be...

george sibbald (12/19/2008)

---

Lynn, its a long shot, but I had a windows SP2 install fail because it could not find a .msp file, and that was a permissions issue...

noeld (12/19/2008)

---

This is a shot in the dark but the First think I believe you should do is to make sure you have "windows" patched at the same level in...

Nope, this isn't a clustered system. Both are stand-alone installs. Both have their own disks as well. Neither of them are connected to our SAN either.

Long shots are worth a try. Heck I'd try a scatter gun if I thought it would help!

I'll give your idea a look at, thanks.

dejanette.gordon (12/19/2008)

---

I see. 😀

Lynn...I want to genuinely thank you for taking an above and beyond extra step to assist me in this matter. In spite of my folly, you...

You can tell that I'm fried and eager for a 2 week vacation. Where do I look to check the patch levels of the OS. As I said,...

I know. This is when I wish a former co-work I worked with else where was here. I could spend hours searching MS Knowledge Base and find nothing....

Jeffrey Williams (12/19/2008)

---

Lynn Pettis (12/19/2008)

---

Dejanette,

I am sure you would help if you could. My problem is with applying SP 3 to a multi-instance x64 server running SQL Server 2005...

dejanette.gordon (12/19/2008)

---

You are both correct; I was just generalizing the numbering sequence issue because I was trying to be thorough by providing some type of example. But you made...

My network people are busy on other issues, so I'm not getting a lot of response from them. I am hitting a wall, and don't know what else to...

I'd like to ask what is differnet between the development/test environments and the production envirnoment.