I'm going crazy over this one, i cant get Alerts to fire in SQL 2005, theres nothing wrong with dbmail or the operator set up as Ive tested...
Ive been tasked with trying to monitor whether a number of Cubes have up to date data in them each day.
Basically I just need the latest...
Has anyone know how much RAM SQL Server enterprise edition can access on a 2003 server
I think it is 32 GB but am not sure
Does UPDATE STATISTICS block or lock tables ?
Ive heard alot on this subject with different opinions RE SCH-M, SCH-S locks etc so I'm not sure...
Separate names with a comma.