does anyone know if this hotfix rollup is cluster aware?

in query analyser run the following

use master

go

exec sp_helpdb

the 3rd column shows database owner

last year it was 400 servers with somewhere in the region of 5000 databases (2 dba's), but after consolidation this year 100 servers with a total of maybe 70tb of...

use in query analayser the alter table statement

for example

alter table mytable alter column mycolumn varchar(100) NOT NULL

Enterprise mangler does some odd things when changing tables due to backwards compatability...

select * from mytable where myid in (select top 5 myid from mytable order by mydatefield desc)

are you running sql server accounts under localsystem or a domain account - lock pages in memory is usually defined under the security policy (i think) for your user account

what's your biggest database size?

select case

when tstarttime=@endtime then datediff(hh,@starttime,@endtime)

when tstarttime>=@starttime and tendtime>=@endtime then datediff(hh,tstarttime,@endtime)

when tstarttime<=@starttime and tendtime=@starttime and tendtime<=@endtime then datediff(hh,tstarttime,tendtime)

else '0' end

from mytable

or thereabouts

if it has mystically doubled in time but the .bak file is the same size then the obvious one to check is in the maintenance plan - check if the...

thats correct - on failover 2 instances - beware you have to have different instance names!!

i agree with lowell though. they shouldn't hardcode the database name. it might be...

not sure i understand the reply - basically turn the passive node into an active node.

no point running 2 active instances on the same hardware unless you go into a...

i'd proboably say install the other instance on the failover node and set it up as ACTIVE/ACTIVE.

at least you can make use of the other node for reporting or other...

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

should cover some of it.

flame!!! right on wangkhar...

I think the key thing here is that developers have to accept that it's the DBA that has to manage the database/server for their application long after...

To Marti, I ask: When I worked in a large shop there were change control meetings daily, weekly, monthly, and development would have had to get their schema changes approved....