jcrawf02 (9/7/2010)

---

LutzM (9/7/2010)

---

jcrawf02 (9/7/2010)

---

Do you suppose 5 minutes to return one row of data will be too much for end users? 😛

Now I just have to figure out what the...

Actually I picture Lutz as Wayne's avatar.

Red Rocks is great. Saw John Mayer there a couple years ago. Need to go back for a concert.

Excellent job, Paul!

I'm sure people will love the next 3. I know I learned a few things.

If you get the transport error, either you're restoring across a network, or the file is corrupted.

Please post the code you are using to do this restore, and list the...

This is fairly simple SQL. Query the backupset table (or another table) for the information you want. Go look in BOL at the columns and choose the data that will...

Then you don't want to get this from the backup job. You want to run a job that will check for this after all the databases have been backed up....

These items are messages. They aren't stored, but there is most of this info in backupset (http://technet.microsoft.com/en-us/library/ms186299.aspx)

You could mail that.

Note that mailing yourself positive results is likely a waste of...

AFAIK, SQL 2000, x86, should run under the WoW environment on the server. I haven't seen much posted about it, but I'll drop a note out on Twitter and a...

Excellent editorial. I definitely find that listening to people, and not necessarily trying to add to their point from my side, is a great source of inspiration and knowledge for...

While it's likely the UK's fault, eating up all the bandwidth while you sip some tea, that wasn't my first thought 😛

I tend not to like db_datawriter as it grants rights to insert/update/dlete to all tables. You might have exceptions, especially if you do any auditing.

I prefer to create a user...

Nicknames have a unique index on them, so you can't pick a name that someone else has.

Seems to be running fine from here. The server is located in the UK. Perhaps the link from them to you has some slowdowns for some reason.

Can you load any...

I would lean towards rights. Can you log in as the SQL Agent service account and manually delete the files?