Viewing 15 posts - 661 through 675 (of 1,129 total)
I am planning to use profiler to find if Auto_stats is an issue or not, is there a better way?
February 26, 2011 at 8:35 am
thanks everyone. I will get back here with some updates. Thanks
February 25, 2011 at 8:01 am
I tested this out today , running a trace all i saw is shared locked. Are you sure this will lock the table , like keep an X lock? Mentioned...
February 24, 2011 at 6:00 pm
That might work, but might also break the access of others.Thanks
February 21, 2011 at 3:24 pm
Sandhya:
I recently used this article as reference and works perfect. You should be able to see the message in the sql log if configured correctly. Thanks
February 21, 2011 at 10:01 am
Unfortunately we do not have power shell running.Thanks
February 21, 2011 at 9:13 am
Thanks. I ran trace with event "Peformace Statistics" and that was shown throughout the trace. Is that an indication of bad statistics?
February 16, 2011 at 11:20 am
Thanks and will do so.
February 16, 2011 at 8:31 am
update..from the previous post which i mentioned step ii is also part of step i. My question is same now, what is the difference between GUI and running through...
February 15, 2011 at 7:00 pm
simon-811452 (2/15/2011)
sp_update_job is definitely the way - the GUI disable and updating the table directly both seem to cause failures.
OK if i follow this correctly you mean to say the...
February 15, 2011 at 2:48 pm
i ran the trace now after disabling the job through GUI and the below following procs are being executed:
EXEC msdb.dbo.sp_update_job @job_id=N'5bd63372-c981-4cef-b18f-2db4b464ee43',
@enabled=0
EXECUTE @retval = sp_verify_job_identifiers '@job_name',
...
February 15, 2011 at 2:46 pm
Is there a MSFT article which points to this? Thanks
February 15, 2011 at 1:45 pm
homebrew01 (2/15/2011)
What service pack are you on ? Sometimes these odd problems occur in early versions, and are fixed in later SPs.
sql 2005 stnd edition 64 bit with SP3...
February 15, 2011 at 1:41 pm
Viewing 15 posts - 661 through 675 (of 1,129 total)