Actually this one: http://www.sqlservercentral.com/Authors/Articles

It should be going on the left menu here soon.

Not a bad idea. You want to write a guest or have me whip something up 🙂

Perhaps should include the idea of is 2008 certification in the works for any...

Keith,

I think you're right, but that's why we have compatibility mode. If it's < 10 or 11, then allow them, but in new versions don't.

The idea of one fragmented and...

Dont' forget estimated taxes. The penalties aren't huge, but why pay them if you don't have to.

your post is rather confusing.

Perhaps you can step back and explain what you were trying to do. The .sql files you specified must be from some application or framework. Please...

Thanks Christian. I like the approach of looking at how to do things wrong.

Does it fail interactively as well as during scheduled running?

When you say the connections work fine, can you preview your data from IBM in the Transfer task?

When do you get the internal consistency error? Perhaps you have a corrupt backup?

I'll award back points, though I didn't think that the question with the answer was that badly worded. I'll remove the "By Default" from the question.

Have you done a try..catch around this? Not sure if it will help. RESTORE might be one of those functions where you can't necessarily trap the error.

I don't think there's a procedure, but why is a group a problem with your application? The application has no idea if it's a Windows login or group that maps...

Documented here: http://msdn2.microsoft.com/en-us/library/ms189751.aspx

The application log is typically the windows event log. You can configure the maint plan to write out a log for each task, such as the backup task.

I don't think you can reduce the size below it's initial size.

You can move the data by moving the clustered index if there are tables in there.

SET ROWCOUNT @num

update

set rowcount 0