Is your backup and application using this DB is working fine?

allow_page_locks is a bit field try =1 and proceed

Try setting the @body_format='HTML' and format your html...

perfect lynn, i got it and i never faced it during daylight savings shift.

one more

http://sqlserverpedia.com/blog/sql-server-bloggers/how-to-decide-on-index-allow_row_locks-and-allow_page_locks/

Can you go through this.

http://www.sqlservercentral.com/Forums/Topic518826-360-1.aspx#bm518862

Possible i faced one with same scenario as my account locked that time.

I changed it to a service account it is fine now but you have to run once manually.

For example a job which runs daily and is in sysjobactivity as starting in 2010 but never finished will just show as normal for it's day to day routine in...

what do you mean by this?

These jobs are not there now or you want job history details or others?

homebrew01 (5/21/2013)

---

I also have old "orphaned" active jobs. I ran across it a few weeks ago when creating a report to alert me about long running jobs and failed job...

I'm not just trying to get the status, I'm looking for jobs that...

SELECT

database_id, object_name(object_id), object_id, index_id, partition_number, index_type_desc,

alloc_unit_type_desc, index_depth,

index_level, avg_fragmentation_in_percent, fragment_count, avg_fragment_size_in_pages, page_count,

avg_page_space_used_in_percent, record_count, ghost_record_count, version_ghost_record_count, min_record_size_in_bytes,

max_record_size_in_bytes, avg_record_size_in_bytes, forwarded_record_count

FROM ...

can you mask the query and post it which you are trying to run from sql 2005.

good , you found it on your own.

please dont suggest to restart servers as it will affect production instead have to identify the root cause for it.

From...