Forum moved and please try to post only what you think is relevant. We don't necessarily need to see the whole log.

I agree things move slowly and if you page out the Windows guy a few times at night, things might change. Or if you don't get a db working fast...

No differences between Truncate on checkpoint and simple I know of. The former is older syntax.

I agree with Michael, I'd run more frequent log backups and then add in another...

The only advantage for QA that I've seen is that it's quick and starts immediately. I don't need to spend time waiting on SSMS to start up, eat system resources,...

Look on the MS site for new things. Most things should be backwards compatible from the T-SQL side.

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...