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.

Users don't log into a database. They log into a server (SQL Server instance) and access a database. As Brian mentioned, only tracking every query would tell you when they've...

In ASCII text, Windows systems, we often have carriage return (CR) and a line feed (LF). Unix can be different.

Look up ASCII codes and experiment. CHR(13) should work, but Excel...

Go with Itzak's book.

Grant is a little shy, but I'd recommend his execution plans book as well. Available as a promotion from Red Gate software in our newsletter and on...

Use charindex/patindex to find the place where the occurs and then SUBSTRING to extract around it.

Ah, interesting. Which culture?

Promotional here means advertising or announcing.

I can't think of one, but I'm sure that there would be something funny to use in the US. Maybe Pseudo-DBA