Viewing 15 posts - 34,621 through 34,635 (of 39,793 total)
The user might own things that the role wouldn't.
September 20, 2004 at 12:06 pm
There isn't a way to limit by user, only by total connections.
September 20, 2004 at 12:01 pm
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...
September 20, 2004 at 12:00 pm
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.
September 20, 2004 at 11:59 am
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...
September 20, 2004 at 11:58 am
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...
September 20, 2004 at 10:02 am
Thanks, and since I'm posting, it worked, sort of ![]()
September 20, 2004 at 10:00 am
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...
September 20, 2004 at 9:59 am
Profiler is probably your best bet.
September 17, 2004 at 9:49 am
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...
September 17, 2004 at 9:47 am
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....
September 16, 2004 at 10:18 pm
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...
September 16, 2004 at 10:16 pm
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,...
September 16, 2004 at 10:08 am
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...
September 16, 2004 at 10:06 am
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...
September 16, 2004 at 10:04 am
Viewing 15 posts - 34,621 through 34,635 (of 39,793 total)