Viewing 15 posts - 4,366 through 4,380 (of 7,496 total)
Adding to PaulBs reply...
-application lifecycle (do all applications need the same software level and/or can they tollerate a sqlserver instance level upgrade)
- cross database ownership only works within an instance...
October 31, 2008 at 6:20 am
CU 10 is out now buildno 9.00.3294
kb:956854
October 30, 2008 at 8:10 am
GilaMonster (10/30/2008)
Try doing DBCC indexdefrag from time to to time on those 'no downtime' systems. It is an online operation.
I know, but I won't ...
That would just couver their needs...
October 30, 2008 at 2:29 am
GilaMonster (10/29/2008)
... SQL 2000? ...
Indeed.
They are not that fond to migrate the db engine.
Their argument is: if it aint broken... don't fix it...
This means that I'll only be allowed...
October 30, 2008 at 1:56 am
Thank you for the feedback.
The majority of our databases indexes get rebuild on a regular basis
Some are not... as always ... no downtime allowed...:hehe: :ermm: :alien:
The final step on...
October 29, 2008 at 1:39 pm
there can only be one DBO user in a database.
That user is actual database owner.
You can add another user using his own user.
If that user needs dbo-privileges, you'll need to...
October 29, 2008 at 6:19 am
GilaMonster (10/28/2008)
October 29, 2008 at 2:22 am
That would be a valid conclusion.
October 28, 2008 at 6:47 am
Just a little add on..
If you want to get an overview of your stats ....
SELECT object_name(id) as ObjectName
, indid as index_id
, name AS index_name
, STATS_DATE(id, indid) AS statistics_update_date
FROM...
October 28, 2008 at 6:31 am
check out Shrink database in Books Online !
(or shrink file if you only want to do a single file)
Be aware that this will interfere with ongoing operations !
October 28, 2008 at 6:13 am
If this is the first alert on this sqlserver, you may have to stop/start sqlagent.
try this:
RAISERROR (17890, 10, 1) with log
October 28, 2008 at 3:05 am
we cycle the errorlog every sunday using a sqlagent job.
If you want to cycle, based on the file size, you'll have to write your own proc.
e.g. this one monitors sqlagent.out...
October 28, 2008 at 1:06 am
Nice feedback all.
Even the ( drum roll ) worked :w00t:
October 28, 2008 at 12:57 am
I didn't realize you actually wanted to consult it with EM. Sorry for that:blush:
With EM Management, SQLServer errorlogs then right click and check that setting.
October 27, 2008 at 2:18 pm
Viewing 15 posts - 4,366 through 4,380 (of 7,496 total)