You mean, restore to production, but to a different db?

this site is driving me nuts with it's losing what you just typed when you try to preview!!!!!!grrr

- Anyway -

I've never done this, so...

Put RPC:Completed in there too.  Seems like you should be getting some sql for the SQL:BatchCompleted.

If it's happening in a stored procedure, I don't think you'll see the 'Alter%', right?

I couldn't believe we bought an access solution (I'm new here, about 2.5 months)!! For some reason the idea of a company selling an access front end just makes me laugh.

The...

I can't get access to access yet, but I've been told it's an mdb, not an adp.  I'm going to have to remote into a user box - so I'll...

A little more info on the subject.  The application is a ms access front end, supplied by a vendor.  One of the users has said that sometimes they want to...

A view will not help at all.

Are 'Cash payments' recorded in another detail table?

Does this table contain LastNo?

If so, it doesn't seem that you need to be storing LastNo in...

If one of these statements were being blocked, wouldn't they deadlock after a certain amount of time?  I have a select statement with a time of 23 minutes in my list!

It's just something that seemed pursuable in our system - most of our apps are vendored so we can't mess with the db.  In this case, one of our apps was responsible, so...

Chalk it up to a consulting firm which did an audit of our environment to consolidate to virtual servers.  They gave this document to my senior who now thinks this...

>>meaning every 20 minutes or so, all statistcs are being updated.

In certain situations, you do not want this happening during a busy time of the day.  It may drain performance.

Is P_MON_CONNECTIONS intended to be run when investigating blocks identified by the previous procs?  first I was thinking it was the main proc which fired off the sp_who logging proc,...

Mohammed - I've added info in red above, which should clarify.

the 'execute%' will get you what you need for now, but there are other things which may be added.  You really need to look for -BkUpDB and your path in:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID...

I was hoping to find these scans in profiler, link them to sysobjects and then take a look at the indexes on the table.  The bulk of these seem to...