No idea, but please post in the appropriate forum. (this has been moved).

Full and diff backups don't use truncate.

The backup scheme depends on what works for your business. If they can tolerate finding a full, then a diff, then a ton of...

Is that path correct?

If so, it sounds like you have a corrupt download. Get the real one from Microsoft.

I'm not sure about the Ethanol, but I tend to agree that we can't blindly switch from food to fuel. It would be better to mandate some type of percentage...

They already are squawking. The new Energy Act passed, just as I was publishing this. I'll comment more in the Feb update, but the solar and wind subsidies were removed....

My apology for the confusion. Actaully I wanted to mention that we cann't allow it to run as Local Admin. It's running as Local Admin.

That doesn't make sense? It's Which...

Because storage doesn't imply order. A view is simply an overlay onto storage.

Just like a table doesn't have an order, a view doesn't. Don't use views to preserve order....

You could set something up to look for the version in the sysobjects table, but as Jeff mentioned, there is no good way to look for when something changed.

If...

The log changes based on data changes.

You can copy off a log backup and then use Log Rescue from Red Gate (I work for them, the tool is free)...

Mike,

The name in the proc is irrelevant to your Call. You need to declare @dbname in your batch, not in the proc.

If I have

CREATE PROCEDURE getaddress

@dbname varchar(20),

@name varchar(4)

I can...

There's no way to do this. The change date isn't tracked.

I agree with everyone that you should only return what is needed and SELECT * might be a problem with future changes, but that wasn't the question.

The question is how...

I've used any of the above techniques. Third parties make the most sense unless you can dedicate someone to go to the bank or somewhere else every day and move...

As johan mentioned, a restart should fix things. Every once in awhile a kill hangs on the rollback.

Extra data can have an impact, but only in the data cache. SQL can easily handle 60GB of data in a few tables.

Are your tables indexed? They should be indexed...