Forum Replies Created
Viewing 15 posts - 36,826 through 36,840 (of 39,818 total)
-
RE: Setting a Default Database for your Logins
Have tended to avoid this because of security, but perhaps that is unfounded.
Good points brought up in the article and above and the more I think about it, the more...
-
RE: Interpreting Memory Counters
No supporting docs (yet). Trying to get some from NETIQ. One of their techs had done a bunch of testing, but I've asked this question of PSS, NetIQ, MS Perf...
-
RE: My opinion on changes to Contest layout
Agree we need to change things a little.
Personally I'd like to see the moderate items (articles, FAQs, Case Studies, scripts) get much more weighting than posting. Posting is too easy...
-
RE: cannot generate SSPI context
Look for a secure channel reset utility on technet. Probably need to get this reset between the SQL Server and the dc
Steve Jones
-
RE: Public Role
Don't use Access!!!!!!!
Actually, some of the access is needed for metadata for access methods as BKelley mentioned. The only table I've locked down is syscomments.
Steve Jones
-
RE: /3gb
By default, the OS gets 2GB virtual (phys mem + pagefile) and the apps get 2GB virtual always. Physical mem doesn't affect this.
When you get a 4GB server, then you...
-
RE: Automating status check db's
Why would your servers not be in "normal" mode? IS this a regular occurrance? If you force this manually to do maintenance, then I'd setup a maint window.
At JD EDwards,...
-
RE: Basic debugger question...
Don't think you need to eb dbo. Have had issues iwth the server running under local system.
Steve Jones
-
RE: What's the best way to update a database...?
Lots of variables there, plus easy to miss an error or exception.
The wait for a disconnection is the problem. I think there are scripts in the script library that are...
-
RE: using more than 2 GB memory
How much memory have you given SQL? With PAE, you don't need the /3GB switch. You still want 2GB for the OS, then give 6GB to SQL, assign this as...
-
RE: Sending Mail
Look here for some more information:
http://www.sqlservercentral.com/resourcecenter/sqlmail.asp
Steve Jones
-
RE: Interpreting Memory Counters
One thing to keep in mind is that going from 2GB to 4GB isn't really a great benfit. A few hundred MB of RAM. The reason? The OS needs memory...
-
RE: "Windows Update" for Sql?
Nope.
Fortunately, there usually aren't that many. This years security push really messed up my world. Basically at this point, you could get the SP3 beta (supposedly stable, and a webcast...
-
RE: Permissions question
I like to not give them dbo, but it depends. If you have good change control and testing, then maybe it doesn't hurt.
Rather than grant what you suggested, create a...
Viewing 15 posts - 36,826 through 36,840 (of 39,818 total)