Viewing 15 posts - 8,086 through 8,100 (of 9,244 total)
it sounds like they may have been separated for adminstrative reasons. That's perfectly valid if that is what you want to do. As the server is licensed from the install...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 8:44 am
Shabba (4/14/2010)
A quick search within SSC will produce numerous topics on the subject of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 8:31 am
THE-FHA (4/14/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 8:30 am
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
Viewing 15 posts - 8,086 through 8,100 (of 9,244 total)