Viewing 15 posts - 8,161 through 8,175 (of 9,244 total)
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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2010 at 6:27 pm
GTR (3/18/2010)
Perry, are sure that will work on cluster?Scott, i think if you need two instances on cluster then you should go for Active\Active clustering with two named instances.
you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2010 at 7:18 am
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),...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2010 at 4:24 pm
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
Viewing 15 posts - 8,161 through 8,175 (of 9,244 total)