One, I don't use Redgate SQL Backup. Two, it looks like the error message basically tells you what you need to do.

One, SQL Server 2008 supports partitioned tables, you may want to read about them in BOL (Books Online, the SQL Server Help System).

Two, how is the ID determined?

Three, good luck....

The first step is to know the structure of the table. Oh, we don't. Can you post the DDL (CREATE TABLE statement) for the table?

Second step, what edition...

ragie (1/15/2010)

---

hi,

I am writing a stored proc where I query a table for a distinct list of values. & then for each row returned, i need to insert a...

Mauve (1/15/2010)

---

And it is best to answer later in the day as the question is usually...

Love you must the easy ones.

Welcome, you are. Any time.

Ready to smack yourself on the forehead??

SET @start_dt = (SELECT dateadd(hh, 19, dateadd(day,datediff(day,0,GetDate())- 9,0)))

SET @end_dt = (SELECT dateadd(hh, 19, dateadd(day,datediff(day,0,GetDate())- 2,0)))

Do the two select statements in your original post get you the correct starting and ending dates (not asking about time)?

I don't read the QotD in the newsletter, I read it on SSC.

In a test environment, try this:

delete from dbo.Table1

from

dbo.Table1 t1

left outer join dbo.Table3 t3

on (t1.OrdID...

Does the database have full-text catalogs?

Kevin Gill (1/15/2010)

---

In fact, I'll go further (and you can't stop me ;o))

Whenever I miss the intended point of one of these questions, it's usually because I've not paid attention...

Kevin Gill (1/15/2010)

---

To my mind, this question could/should have been moderated and edited to make it clearer.

Even though I would have got it wrong had it actually been asking...

A thought I had, what if the DBA interviewer was actually trying to see one or more of the following:

1) How you handle pressure/adversity

2) How much training will this candidate...