Forum Replies Created
Viewing 15 posts - 36,781 through 36,795 (of 39,771 total)
-
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...
-
RE: Too many dbo's?
In production, avoided. Though in my world, with dozens of servers, we have to let some people manage their db while we manage the server.
In dev, I try to avoid...
-
RE: Implementing Encrypting File System (EFS) with SQL Server
I've got a review coming out next week or the following.
I spoke with the Litespeed people at PASS and they mentioned that they had worked with MS and taken advantage...
Viewing 15 posts - 36,781 through 36,795 (of 39,771 total)