You can do the integrity check as part of the maint plan - Just not before backups.

When you get to that screen it will have something like

[] Perform Integrity Checks
...

Okay, this is sort of a bug in the Maint Plan Wizard.

You most likely checked the box to check database integrity before backups. What happens is that if any...

Here in southwest Ohio:

Saturday and Sunday sunny and 70.

Monday pretty much the same.

But I was at work a good chunk of Saturday and all day Monday. Bummer!

Makes sense now.

Like I said, I'm lazy and just use the maint wizard. Break them into User, IS, System and then any...

Are you actually dropping the original table?

In the "Select into" you get all the data. As long as you don't drop the original table, if you want to back off...

I don't think Select Into configures indexes and keys.

True - but it all depends what you're trying to do and the size of the table involved.

If I'm just trying to...

It sounds like you're overunning your checkpoints. Maybe try:

SELECT YEAR(Datefield) MONTH(Datefield), MAX(Datefield)

FROM TableName

GROUP BY YEAR(Datefield) MONTH(Datefield)

ORDER BY YEAR(Datefield) MONTH(Datefield)

Then take the results and do search and replace:

DELETE FROM TableName

WHERE Datefield...

Depending on how many records you want to save it might be faster to do a

SELECT *

INTO NewTableName

FROM TableName

WHERE DateField > DateParameter

GO

Truncate Table TableName

GO

INSERT INTO TableName

SELECT *

FROM NewTableName

Just my...

If the new table doesn't exist - this will create it:

SELECT *

INTO NewTableName

FROM TableName

If the new table already exists:

INSERT INTO NewTableName

SELECT *

FROM TableName

FROM BOL:

RESTORE HEADERONLY

FROM

WITH FILE = file_number

Identifies the backup set to be described. For example, a file_number of 1 indicates the first backup set and a file_number...

I am sort of hashing this out in the Moving tables between filegroups thread.

Unfortunately, it depends on clustered indexes. You just can't do an Alter Table command.

Now here is...

Are you absolutely sure you are loosing characters?

1. When you select from the table in the query analyzer are you using data table or textual output?

2. In the QA select...

I've have the script. Thank you!

You mention you are keeping a a list of the tlog in a control table. Why not pull...

I have scanned its figures I know it's legs I have looked at some of the...

Please. I'll PM you my e-mail.

But while you're at it, throw a copy out in the contribution center. I'm sure others would like...