Viewing 15 posts - 7,096 through 7,110 (of 9,241 total)
GilaMonster (5/20/2011)
You have another log backup job running?
or someone\something is taking a log backup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2011 at 9:27 am
2008 and 2008 R2 may reside on the same hardware
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2011 at 7:53 am
also you want to be using the sys.database_principals catalog view and not sysusers. This should be better
declare @sql nvarchar(max)
set @sql = ''
'
print ''Dropping '+name+'''
execute master.dbo.sp_revokedbaccess '''+name+'''
'
FROM
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2011 at 6:17 am
you're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2011 at 6:13 am
you're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2011 at 6:12 am
bill 36362 (5/19/2011)
So I have to upgrade server to Enterprise?
Either upgrade to windows 2003 Enterprise 32 bit or windows 2003 Stndard 64 bit 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2011 at 12:42 am
muthukkumaran (5/19/2011)
Perry Whittle (5/19/2011)
bill 36362 (5/19/2011)
all 32 bitStandard 32 bit will only support a max of 4 GB RAM
Perry,
SQL 2008 32 bit supports Operating system maximum.
It does indeed but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2011 at 12:41 am
bill 36362 (5/19/2011)
all 32 bit
Standard 32 bit will only support a max of 4 GB RAM
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2011 at 5:53 pm
EdVassie (5/18/2011)
When it comes time to put the new server live,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2011 at 4:35 pm
king_emperor_in (5/19/2011)
went to the SQL Server Configurations Manager and in Startup Paramaters i put "-m;" in front of the others.then re-started the service.
wrong
king_emperor_in (5/19/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2011 at 4:29 pm
bounceaball (5/19/2011)
I am seeing different results.
I have attached the screenshot...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2011 at 4:07 pm
have you checked the sql server logs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2011 at 4:00 pm
bill 36362 (5/19/2011)
I am upgrading RAM from 4GB...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2011 at 3:56 pm
they're just warnings and can be ignored providing you do not intend to install SSRS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2011 at 3:35 am
the ghost cleanup is designed to only delete small amounts of records at a time to avoid swamping the DE performance. With lots of rows you may not see an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2011 at 3:25 am
Viewing 15 posts - 7,096 through 7,110 (of 9,241 total)