GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

This whole post makes me laugh..

Basic Troubleshooting 101:

1. Find out WHY you have the problem in the first place

It is clear that GT-897544 has very little real...

GT-897544 (2/16/2010)

---

I do agree with you guys, we need to find a problem. But how good is keeping database offline\Suspect mode and looking for solution and keeping business down for...

GT-897544 (2/16/2010)

---

GilaMonster (2/16/2010)

---

Oh for...

This is what I can find on the subject:

http://support.microsoft.com/kb/919155

DBCC CHECKDB does take a lock on tables. The above is about DBCC itself recording a timeout, but in a system...

Alvin Ramard (2/16/2010)

---

One of the things we're seeing is the fact that so many people lack troubleshooting skills. They don't know how to find out what's wrong so they...

CirquedeSQLeil (2/16/2010)

---

Chad Crawford (2/16/2010)

---

RBarryYoung (2/16/2010)

---

Just knowing that I am helping someone is what makes it all worthwhile.

(if that doesn't make sense, then note closely the dates & times in...

SuzDBA (2/16/2010)

---

For this post let's assume I have 2 servers: Server A and Server B

Server A will have 3 Databases: DB1, DB2, DB3

Server B will have 3 Databases:...

GT-897544 (2/16/2010)

---

sqldba551 (2/16/2010)

---

Hi,

As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT...

GT-897544 (2/15/2010)

---

GSquared (2/15/2010)

---

Bru Medishetty (2/15/2010)

---

I would run the query

select @@version

and look at the output, where the end part shoes if nothing if it's a physical server and if it's on...

There are a few different ways to do this. The one I usually find works best is to create a table of the weeks you want to query against...

Bru Medishetty (2/15/2010)

---

I would run the query

select @@version

and look at the output, where the end part shoes if nothing if it's a physical server and if it's on a Virtual...

I can't tell for sure without some sample data, but it looks to me like the CTE should end up with an infinite loop in it based on that Join...

Check out "DateAdd" in Books Online. You can add -2 years to get what you're looking for.

You should be able to view the query in the report properties.

If not, run a trace and open up the report. If the trace includes the text for batches,...

My prior employer worked on the NYSE schedule, and they have the day off. (The only thing I really miss about that job was the huge number of days...