Viewing 15 posts - 32,221 through 32,235 (of 39,748 total)
I definitely lean towards multiple databases, 1 per app, especially for scalability in case one client outgrows the system or causes issues for others.
However, there have been some good points...
April 20, 2007 at 7:41 am
The basic answer is that you don't grant more permissions than are necessary. DBO can do pretty much anything inside the database, backup/restore, grant new users rights, change security, etc....
April 20, 2007 at 7:37 am
Some great comments and things to think about. I was really interested to see what you might think because I think we'll always have jobs.
MDX is a language for cubes...
April 19, 2007 at 9:14 am
Antares, I agree with that.
No calculators in school!
April 18, 2007 at 2:59 pm
I don't think any of this will fade away. Are cars that much better than they were 30 years ago? I still see lots of mechanics out there.
I know TVs...
April 14, 2007 at 8:57 am
Thanks for the comments and that's a great idea for 10 ways to get promoted. I'll work on that one. Not sure I have 10 ways, but I have a...
April 13, 2007 at 5:10 pm
Leaving aside the nonsense on the builds and the apparent confusion from MS on what fixes what.
I still stand by the answer that you only need to apply the latest...
April 13, 2007 at 4:58 pm
Can't keep SIDs, but you can use sp_help_revlogin to script out and move logins with the same passwords.
April 13, 2007 at 11:14 am
It's a parameter in the service startup, so it should be in the registry. You can get it from xp_regread or any registry scripting
April 13, 2007 at 10:42 am
But did you get to keep the red stapler?
I think I was there in the closet/turned server room. Just behind the rack to the left.
April 13, 2007 at 10:00 am
Hugo, I'm not sure that invalidates the answer. Whether you are on the QFE track or the GDR track, you only apply the latest hotfix that you want to apply....
April 13, 2007 at 7:19 am
This is close to what I've been asking for. I was hoping for quarterly service packs, but rollup hotfixes work just as well.
Plus they shouldn't have features!
April 12, 2007 at 8:48 pm
xp_fixeddrives
Or maybe use VBScript and the FileSystemObject. That might be the easiest.
April 12, 2007 at 3:10 pm
Viewing 15 posts - 32,221 through 32,235 (of 39,748 total)