newbie2sql (3/19/2010)

---

Hi Perry Whittle

Solution you had given me is correct for my solution. Currently I am checking the permissions and...

yes, that goes without saying!

OK, i made this real easy. The screenshots below shows the registry entries created when installing SQL Server and the instance configuration in the installer. Notice the default instance (MSSQLSERVER)...

i dont see whats wrong with my script?? :ermm:

As Gail says "no commit, no dice" 😉

it's also worth noting if the database is in simple or bulk-logged recovery the create\alter index is not fully logged!

you...

try this

--uncomment the where clause and specify a database user

--to get permissions for a single account

USE yourdbhere

SELECT

'Permission "' + CONVERT(NVARCHAR(10), permission_name) COLLATE Latin1_General_CI_AS + '" "' +

case CONVERT(NVARCHAR(10),...

the index which is being rebuilt is stored in a temporary area and brought in when the rebuild has finished to replace the existing index. An outage shouldnt really have...

Scott Wise (3/4/2010)

---

How would one go about adding an instance to a SQL2008 cluster? I am running a Server 2008 Cluster with the default instance installed and working beautifully,...

totally agree Thor.

the revoke thing is a little ambiguous i agree. I understand it as

if you take the user account out of the ACL you have neither allowed or...

you revoke NTFS permissions by not adding entities to the resource ACL list, this prevents access but doesnt deny. Access could still be granted via membership of another group.

All I'm...

hi i realised that. But whether sql, windows (NTFS), etc be careful with deny always revoke where possible

the other issue here is your explicit use of deny, always revoke rather than deny excedpt where absolutely necessary. Deny can have some very undesirable effects

just a sanity check, have you verified in the sql server logs that SQL server is using locked pages. Check the instance startup text in the log to verify lock...

are you copying and pasting the text from this site to the command prompt?

if not, can you post the exact command you are using?