thanks for the replies I'm developing an in house DBA admin toolset which will go across a number of servers, so i'm not wanting to put a trace on...
The only info i could get logged to the sql error log were when i put a trace on to do so, but even then the alerts were not firing, the deadlocks...
have checked that out, and everything works fine doing that, the nofication comes through Still cant get the system ones ie 1205 etc to work though,...
thanks for the reply the errors are not raised in the app log how do i use the raiseerror with log? cant find too much on it on the web, but thats...
hi there 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...
thanks Its the actual MDX query to get the up to date date I'm really after p
HI there, 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...
thanks, I just found this SQL Server 2000 Enterprise Edition can support up to 64GB of RAM. How much RAM SQL Server 2000 Enterprise Edition can use...
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 thanks
thanks I'm quite sure indexdefrag doesnt update stats, was just wanting to know which part of the reindex statement actually updates the stats...
thanks guys, Just one more thing, I cant find out much info on the WA_SYS indexes or statistics. As REINDEXing a tablename will drop and create...
hi, 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.
