The user might own things that the role wouldn't.

There isn't a way to limit by user, only by total connections.

That is strange. Under what account does the DTS package run? Is is a sysadmin? Is your DB owned by sa? Does this happen if you run them interactively instead...

I'm not sure what you mean by shares. As far as logins, search sp_help_revlogin on MSDN and you can use that script to move logins for SQL 7 and 2000.

Nice complement and indeed I get lots of questions submitted, well not lots, but probably 1 of 10 is submitted. However, most people don't want to get credit because of...

I'm not sure what you mean? You can go back and answer the old questions.

We're also getting a book ready with previous questions of the day for sale. Look for...

Thanks, and since I'm posting, it worked, sort of

I agree with Adam. I knew that people would think the answer was wrong, but it isn't. This is a common source of problems in SQL Server, people see certain...

Profiler is probably your best bet.

We do run a monthly newsletter to summmarize everything that's come out.

At this point, we don't have a good way to give you an option and honestly if we went...

Backing up to tape isn't ever risky. Restoring from tape is. And when it's risky, so is your reputation, job, etc.

I store one day on disk, the rest on tape....

Thanks for the comments. This was an update of something I'd written a few years back, but it still applies.

Fillfactor and your indexing is something that needs regular maintenance. If...

I think both are needed. I use both, backup to disk because it's faster. Not necessarily the speed of the tape these days, but the speed of mounting, moving, changing,...

Haven't used them, but protegrity was at PASS and it was a pretty good looking system. A little $$$ for me, but it seemed to be setup right, key escrow...

Both might be the best choice. We had some complaints about this for people that don't want to go back. However if I answer 1 question right, is 100% the...