In line with that, does PASS have a five year plan? Beyond 5 conferences? As Grant and Jack mentioned, it doesn't appear that PASS does much to help chapters or...

You can use "RunAs" and launch SSMS this way to connect with a higher privilege account. We used to do that in the W2K days.

There's nothing like this that I know of. You could probably write something that would spawn them a session with a password, or would change the pwd, email it to...

Database Pork Chops

---------------------

4 large chops, bone-in

cayenne pepper

flour

sharp knife

trebuchet

With the knife, sharpen the end of the bones until they achieve a dangerous point.

Liberally coat the chops with flour, the better to...

Ah, my confusion. I was thinking this was a slow restore. My mistake.

GSquared has the reason it's not recommended.

I have used usp or even sp (no underscore) to prefix things.

I do what GSquared does. Define a var.

I like Bru's idea. Create a job to just send all "new" backups across the pipe on a regular basis. That way you'll be moving files as quick as you...

The problem with SQL and networks is that it doesn't handle any delays well. A file copy will retry and work through small glitches. SQL doesn't because the delays can...

We use Rackspace here and at Red Gate. Has been OK. Can probably get you someone to talk to at Red Gate if you want it.

No apology needed. I thought that was close, but it wasn't an attack, but more of a comment that I saw out of disgus or frustration.

I haven't heard back, and...

But doesn't the roll forward include the log records in the full backup? The backup starts, this 2.1B row trans then hits a table that's got some pages in the...

I didn't either. Good trivia item. Probably will stick with me now.

We do not condone brain dumps and will remove any links. We also report the poster and site to MS.

The information you need is on the MS site, and there...

What about a 2B row transaction that occurred during the backup? Wouldn't that end up in rollforward?