Viewing 15 posts - 8,086 through 8,100 (of 9,241 total)
mhilligas (4/15/2010)
The install does not allow me to install a new instance.
could you expand on this a little more please. What error do you get. Re running the installer will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 8:19 am
something along the lines of
declare @deldate datetime
set @deldate = cast(dateadd(day, -3 , getdate()) as nvarchar(20))
EXECUTE master.dbo.xp_delete_file 0,N'DRIVELEETER:\PATH',N'BAK',@DelDate, 1
should help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2010 at 4:13 am
Hi
if you are currently using personal edition are you sure you need the massive leap to SQL Server 2005 Enterprise edition???
sivark1 (4/14/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2010 at 4:03 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2010 at 3:25 am
do you mean recommendations from the tuning advisor?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2010 at 3:18 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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😛
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2010 at 10:47 am
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2010 at 10:44 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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2010 at 6:15 am
best way
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2010 at 12:26 pm
Viewing 15 posts - 8,086 through 8,100 (of 9,241 total)