yuvipoy (4/20/2014)

---

Lynn Pettis (3/29/2014)

---

For this particular issue, possibly no real benefit. The problem we are having is that we can't see what you see which means all we can...

Let me get this straight, you want the data in each column sorted in ascending order independent of the relationship of the data.

Please explain the rational for this please.

Fix what, being able to open up the current database mirror? One, it isn't broken so nothing to fix. If you need to open it you either failover...

Does this return what you expect?

Select (e.FirstName + ' ' + e.LastName) as EmployeeName,

c.CustomerID,

o.OrderID,

o.OrderDate,

SUM((r.UnitPrice * r.Quantity) - (r.UnitPrice * r.Quantity * r.Discount)) as OrderAmount

FROM Orders o

Inner Join Employees e...

The mirrored database is not available for reading. Anything you want to do, you will need to do on the principal database.

Actually, it was milliseconds. 😉

brad 51473 (4/19/2014)

---

Shortened it up a little bit, but still getting an error on the last line - no matter what is on that line. Here is a link to...

Need to see the whole procedure.

SQLRNNR (4/19/2014)

---

Lynn Pettis (4/19/2014)

---

Greg Edwards-268690 (4/19/2014)

---

I particularly like...

Well, here is the other part of the problem, and without actually scrolling back through, I seem to remember someone asking you to post what you have tried to solve...

Greg Edwards-268690 (4/19/2014)

---

I particularly like the fact that...

It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding suspect databases.

Jagadeesh Chowdary (4/19/2014)

---

If the Database is in Suspect mode then follow the below steps to recover ur DB

>Stop the SQL Service

>>Copy the MDF and LDF file and place in other...

Your initial post indicated that this was "urgent" but you have failed to provide us with all the information we need to really provide you with any meaningful assistance. ...

TomThomson (4/17/2014)

---

EasyBoy (4/16/2014)

---

Thanks Scott and Lynn for your inputs.

As suggested by Scott i have made changes in existing index with filtered index (suggested by Lynn). And i am able to...