Viewing 15 posts - 8,161 through 8,175 (of 9,241 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2010 at 4:07 pm
Scott Wise (3/4/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2010 at 3:44 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2010 at 10:35 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2010 at 7:51 am
hi i realised that. But whether sql, windows (NTFS), etc be careful with deny always revoke where possible
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2010 at 8:31 am
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2010 at 3:02 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2010 at 6:17 am
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2010 at 11:07 am
Jpotucek (11/25/2009)
I have SQL Server 2005 Enterprise edition on a Windows 32bit Advanced Server 2003.
I recently added 12 GB to the Server bringing the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2009 at 2:39 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2009 at 8:03 am
S.K. (11/19/2009)
if you install node A on the D:\program files\......
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2009 at 4:04 am
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2009 at 12:54 pm
JC-3113 (11/18/2009)
Hi Perrydoes that just give me a llst for the person logged in ?
Thanks
Jim
no, not especially. Is that specifically what you are looking for?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2009 at 11:23 am
Greetings all
Vivien Xing (7/8/2008)
rbarryyoung (7/8/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2009 at 3:59 am
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2009 at 4:42 am
Viewing 15 posts - 8,161 through 8,175 (of 9,241 total)