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?

Jpotucek (11/25/2009)

---

quick follow up question..

I have SQL Server 2005 Enterprise edition on a Windows 32bit Advanced Server 2003.

I recently added 12 GB to the Server bringing the...

ok, so for any given account on the server you want to ascertain any objects owned in any database, is that correct?

also, you are using SQL Server 2005 (i know...

S.K. (11/19/2009)

---

For starters: the syspolicy_purge_history job -- needs to be updated for the virtual server name of the sql instance;

if you install node A on the D:\program files\......

Never mind the upgrades, with SQL Server 2008 the real gotchas come in when installing a clustered instance. All sorts of little nasties to contend with there 😉

no, not especially. Is that specifically what you are looking for?

Greetings all

Vivien Xing (7/8/2008)

---

rbarryyoung (7/8/2008)

---

Actually, it is not valid to exclude 'dbo' here. If a Login owns a database, then they are user 'dbo' in the database and they...

verify connectivity to the sql server and database. from a remote machine start a sqlcmd session and connect then query the database. What results do you get?

what errors particularly. Can you post some samples

Lyn

its not a good idea to hijack another thread best to start your own. That aside can you post details of the setup log as Santosh has done Some idea...

santosh_chandel (10/2/2008)

---

**********************************************************************************

Products Disqualified & Reason

Product ...