Can you run the differential backup manually from SSMS?

I don't think any further responses are necessary here, but here is an "interesting" omg moment.

You could look at using Partitioned Views. Basically, you create a table for each year then build a view over the tables. You will find more information regarding...

Why do you want to do this?

yesso (7/6/2009)

---

The last backup was a full backup. Nevertheless, the database is in full recovery mode, which means that it had a transaction log, and ought to have been...

A good reason for the OP to be a bit more professional and expalin what the problem is instead of ranting about how much the site s****.

Not sure as I am not using SQL Server 2008 (yet) and we currently aren't using SQLCLR, but it is possible that some of the internal processes may be using...

arthykannan (7/6/2009)

---

You guys shuck. every time we have to go and register or it says we have to go and click the freaking link. and the email doesnt get...

SCHEMA_NAME was added in SQL Server 2005. I don't know off-hand what you would use as a replacement in SQL Server 2000.

Edward (7/6/2009)

---

Its only a theory it should be applicable to things which match the condition

1 the cursor selects only distinct ID's

2 each steps it selects from a different table using...

Like this:

declare @ADateTime smalldatetime;

set @ADateTime = '2009-07-05 09:00:00';

select @ADateTime, year(@ADateTime);

You may want to spend some time reading Books Online (BOL, the SQL Server Help System that may be accessed from...

This?

declare @TestInt int;

set @TestInt = 425699;

select cast(@TestInt/100.00 as decimal(10,2);

There really isn't enough information to provide a really good answer. Could you provide the DDL for the table(s) involved, sample data (in a readily consummable format that can...

It isn't a stupid question at all. the problem I see with it is that it is extremely broad and vague.

Perhaps you could provide more background information regrading what...

WayneS (7/6/2009)

---

Lynn Pettis (7/6/2009)

---

You may want to search this site a...