Okay, so what is the log_reuse_wait_desc in sys.databases? Post the results of this query:

SELECT

D.name,

D.recovery_model_desc,

D.state_desc,

...

Dave Ballantyne (2/9/2011)

---

Brandie Tarvin (2/9/2011)

---

Actually, that's just the wind blowing up your kilt. @=)

Seriously, though, are...

I'm going to make a couple of comments:

1. If you use the DATE data type then you won't have to worry about time so a query using WHERE expiry_date...

I'd also be interested in seeing a DBCC CHECKDB() run on it as well.

This error, "SQL Server detected a logical consistency-based I/O error: incorrect checksm...." makes me wonder if...

Roy,

Location is right for now. Will likely change this summer.

Ferguson (2/8/2011)

---

Jack Corbett (2/8/2011)

---

Ferguson (2/8/2011)

---

I am not saying I would not consider you, but I will try to answer your perhaps rhetorical question.

Someone who as a young adult decides to...

Ferguson (2/8/2011)

---

I am not saying I would not consider you, but I will try to answer your perhaps rhetorical question.

Someone who as a young adult decides to put in the...

Tom Brown (2/8/2011)

---

Seems like VirtualBox is the preferred choice.

Just wondered why, no one mentioned VmWare or Hyper-V?

As far as I know Hyper-V is only available on Windows 2008 Server...

I agree that this is a much better posting, albeit one I am not qualified for.

I think that you should almost always include "or equivalent experience" when listing a degree...

I can do virtual presentations although I prefer to be in-person if I'm traveling to that area for something else, or you'll pay my travel costs.

I use Virtual PC right now, but it doesn't support 64-bit so if I ever get a machine with enough memory to run 64-bit guests I'd use VirtualBox.

For SSRS I'd check to see if any reports have been created against them. If there are you can also see the use history of the reports. ...

Do you want to return rows that within the upper minute? Your current query will not return rows like this: '2011-01-03 012:00:01'

You also didn't answer Gus' question? ...

I agree with mister.maggo...

Call me crazy but I don't like giving db_datareader and db_datawriter permissions. I prefer to create my own custom roles that have only the needed permissions and then assign...