Viewing 13 posts - 196 through 208 (of 208 total)
its ok, iv got it working !
thanks all for your help!
i must keep in mind what you say about multiple records tho!
March 29, 2010 at 4:43 am
oh sorry i understand now
should not be a problem as you can only create or delete a product one at a time!
how can i check if a mail account has...
March 29, 2010 at 4:25 am
my thinking was the trigger would only be activated upon a new entry being CREATED?
why would i want to loop through all the records when i only want the...
March 29, 2010 at 3:49 am
i actually only want to email on a create and delete. It is a stock table so really it should not have that many creates or deletes.
March 29, 2010 at 3:04 am
ill try that and see how we get on
thanks grant for your help
March 16, 2010 at 9:45 am
yea document looks good, it should give me a clearer idea what im looking at
currently the cost threshold is set at 5 - i have no idea what that is...
March 16, 2010 at 9:03 am
THE COLUMNS ARE
TYPE WAIT TIME S PCT RUNNING PCT
March 16, 2010 at 8:31 am
DO THESE STATS INDICATE ANYTHING?
LCK_M_S91672.272.10 96.69 ...
March 16, 2010 at 8:29 am
oops i was using exec sys.dm_os_wait_stats
instead of SELECT * FROM sys.dm_os_wait_stats
March 16, 2010 at 8:23 am
help appreciated anyhows ssc!
March 16, 2010 at 8:19 am
no indexing done on a nightly basis, and its all queries that can get slow regardless of age
March 16, 2010 at 8:14 am
how do i gateher statistics with sys.dm_os_wait_stats?
March 16, 2010 at 8:09 am
wait statistics for disks and processor just
physical disks range from 0-160, and processor really no waits at all
March 16, 2010 at 7:15 am