Is it up to 500 and the next row would through it over?

Does this have to happen regularly, like with every import?

This sounds like something I might tackle in an...

It appears the site is just a place where they link to Google Ads and Amazon for purchase, so you're welcome to go there. I don't see any value in...

Great comments and glad you all liked the article. I think Dave Ramsey is good as well, and we've used the snowball method for consumer debt and it worked well.

6%...

Hey, I resemble that remark.

On the hardware thing. If loads are...

There's always more work. Remember that when you think you have to finish something up to clear the decks.

I'd think that everyone would connect with those credentials. What else is set on that tab?

When you restore, does the database exist?

What if you had a database and restored over it. Still 3 hours? are the backups local on the server?

I'm not sure how you could do all that. Perhaps kick off an SSIS package or a job that runs a VBS script (or Powershell) to do this?

Things are more blocked out in SS2K5. AFAIK, you cannot alter the system tables.

What do you need to do?

Omri also runs the North Va SQL Server User's Group. Can probably contact him there or at SQLFarms.

Don't think you can do this.

Database Mirroring might be a better solution for you. course not sure you can backup there.

Why not backup off primary?

Hot spot? I'm for decoupling things like this. What if you need to move a database to a new server because it's getting busy? I would have avoided an all...

Not that I know of.

I'd put in every database and use a script to create/alter/grant permissions.

Lots of advice here.

Go with R10 or R01, no R5. The only place I might do R5 is for backup files, and I'd keep them on a separate array. That's...

I haven't seen a free tool for SS2K5, but I have seen some for sale.