Viewing 15 posts - 8,101 through 8,115 (of 9,253 total)
i have an SBS 2008 server which has the default sql server embedded instance installed for SBS monitoring. I also have extra instances installed for web databases. Have you tried...
April 14, 2010 at 3:35 am
Toby White (4/13/2010)
(it didn't in 2005 standard)
This was enabled for SP3 CU4 on SQL Server 2005 Standard and SP1 CU2 for SQL Server 2008 Standard
April 14, 2010 at 3:25 am
Paul White NZ (4/10/2010)
Personally, I prefer to use documented and supported features wherever possible 😛
was this some sort of joke then, maybe i am missing something vital, you always like...
April 12, 2010 at 6:33 am
Paul White NZ (4/10/2010)
Personally, I prefer to use documented and supported features wherever possible 😛
hmm, yes i'm sure you do 😛
April 11, 2010 at 11:36 am
personally i prefer the function, it works on SQL Server 2005 as well and does exactly what it says on the tin. Its undocumented for a very good obvious reason...
April 10, 2010 at 11:57 am
place your Tempdb on a separate array and size it appropriately + then some. It shouldn't then get to the point where it needs to grow again. Any file shrinking\growth...
April 10, 2010 at 10:47 am
Give this a try
select 'create login ' + name + ' with password = ' +
sys.fn_varbintohexstr(password_hash) + ' hashed, sid = ' +
sys.fn_varbintohexstr(sid) + ', default_database=[' + default_database_name...
April 10, 2010 at 6:15 am
best way
April 10, 2010 at 5:51 am
xinyu.wang1 (4/10/2010)
active/passive, active/active are obsolete terms. Now the term is multi-instance.
It's not obsolete as active\passive refers to the Windows cluster itself and not SQL Server!
Example: A 2 node Windows cluster...
April 10, 2010 at 5:48 am
Niyala (4/7/2010)
Suppose I have two instances running on the Active node. Two instances on the passive node.
if the passive node has 2 instances then it is not passive is it??????
Take...
April 8, 2010 at 12:26 pm
BOL always has some inconsistencies. In the copy i have it says you can move it but not recommended as if you do it is always returned to the Binn...
April 7, 2010 at 12:04 pm
NJ-DBA (4/5/2010)
correction- i think it was “Read servicePrincipalName” and “Write servicePrincipalName”
Correct they are the permissions to assign in ADSIEDIT to the service account. You also need to trust the...
April 7, 2010 at 10:43 am
george sibbald (4/7/2010)
does SQL rely on info in the master database or the registry? I expect and hope the registry but have never actually tried out this scenario.
as far as...
April 7, 2010 at 10:38 am
Viewing 15 posts - 8,101 through 8,115 (of 9,253 total)