Viewing 15 posts - 151 through 165 (of 297 total)
You should review the Security Best Practices paper from Microsoft. This will give you a good head start.
April 2, 2009 at 7:50 am
i have this scheduled for next weekend...will keep updating...
April 2, 2009 at 7:30 am
The /3GB switch isn't part of server start up. I thought /3Gb and / PAE are exclusive. Is that not true?
April 2, 2009 at 6:25 am
I don't have something that specifically allows a user to do that. However, I can see how that can be done using dynamic SQL.
You could alternately provide securityadmin (server role)...
April 1, 2009 at 7:40 am
Hey no worries...sometimes critics are you're best friends 😀
March 31, 2009 at 1:26 pm
The workstation components, books online and development tools option selected during the installation is will install these on the primary node only. You will need to install these separately on...
March 31, 2009 at 1:06 pm
I believe you will need to provide
ALTER ANY SCHEMA
CREATE PROCEDURE
EXECUTE
privileges on the database.
March 31, 2009 at 12:33 pm
Open the below in query window 1 and select up to "execute until here". The rest of the code is for cleaning up these temp objects.
USE master
GO
CREATE LOGIN test WITH...
March 31, 2009 at 12:22 pm
During the installation you will select "Create a SQL Server failover cluster" option below the "SQL Server Database Services" option (Page 40 of the document). This will install the database...
March 31, 2009 at 11:56 am
I've done this in the past when developers / users required access to the system tables / procs which required system admin or some other server level privileges.
It worked for...
March 31, 2009 at 10:12 am
Richard,
There is no log entry that says AWE enabled.
John,
I was looking in Task Manager to see how much memory SQL is using. I looked at the Total Server and Target...
March 31, 2009 at 7:50 am
Before the reboot...
Configuration option 'awe enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.
Post the reboot...
Set AWE Enabled to 1 in the configuration parameters to allow use...
March 31, 2009 at 6:54 am
That is correct. The domain account will need to exist before you can add it via SQL Config Manager.
Outside of the account creation and assigning it to the service...
March 30, 2009 at 10:00 am
Viewing 15 posts - 151 through 165 (of 297 total)