To my knowledge the table description is resident in Access ONLY.  You can add columnar descriptions in SQL but not table (that I know).

I would assume you will need to...

2 ways of handling this

#1  Basically you have 2 tables A.  Current activity, B. Conflicting stored-procedure combinations

1st item of business is when the stored procedure fires that you want to queue READ...

SQL Profiler (Found inside Enterprise Manager)

Only selections you need should hopefully be:

TSQL > StmtComplete

Stored-Procedure > StmtComplete

Forget where these are under

Show Plan All

Show Plan Text

Execution Plan

For the fields to capture add...

I would look at possible contention inside of your TEMPDB table.  What is the size of your TEMPDB database and hard disk size?

I would alos probably turn on low-level profiling...

Please see thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=170073.

Same topic.  Has multiple postings

Have you looked at ROLLBACK TRAN T1?  You will need to build in @@ERROR check to be the RETURN from the nested procedures and interrogate and IF there is an...

Something like this?

DECLARE @ThisMonth DATETIME

DECLARE @NextMonth DATETIME

SET @ThisMonth = '2005-03-24'

IF DATEPART(DAY, @ThisMonth) <> 1

  BEGIN

    SET @ThisMonth = DATENAME(YEAR, @ThisMonth) + '-' + DATENAME(MONTH, @ThisMonth) + '-01'

  END

SET @NextMonth =...

bummer....  I would check sp_who2, sp_lock, and possibly run profiler to see if you can capture what is going on....

I suggested moving to ADO from RDO because RDO is no longer supported or recommended. ADO on the other hand is still the connection of choice (for now at least) and...

Steve,

No offense taken.  That wouldn't be the first (nor the last probably) that I have been called a girl .  I just...

It could be an ordering thing as well.  IF SQL was installed AND THEN the server was renamed there could be problems....

Why not change the stored-procedure to try and perform the following?

IF EXISTS (SELECT * FROM dbo.table WHERE criteria)

  BEGIN

    UPDATE...

  END

ELSE

  BEGIN

    INSERT

  END

Does the account that you are using for the scheduled backup (i.e. the userid that the job will RunAS) have rights to get to your F:\ drive?

1.  I would switch the application to use ADO v. RDO

2.  I would change the UPDATE portion of your equation to use stored-procedure v. AD-HOC query.  Your timeout may be...

I know in SQL Profiler (SQL 2K) you can open the trace file and then under File > SaveAs select table....

Is this available in 7.0 version???