Thanks for the suggestions.  I don't know that any of them apply.

SQL Agent is already running (and running other jobs).  The Job in question runs every minute from 4 am...

Thanks, Linda.  I'm loading my demo copy right now, then I'll look it up in BOL.

Elliott

Thanks for your reply.  We have been scrutinizing the same comparison of features and trying to determine what it means.  Nowhere in the Microsoft info do they specifically talk about...

Thanks for the clarification, Remi.  It worked fine.

And thanks for the tip on changing the context, Phil.  Now I can script something like:

Set strSQL='USE ' + @db + ' '...

Thanks Remi,

sp_MSForeachDB appears to scroll through the databases.  But when I attempt to use Information_Schema.columns, the context appears to remain in Master.  In other words the column names that are...

Run sp_who in Query Analyzer to view the connections to the current database.

See Brian Knight's stored procedure, usp_Kill_Users, to find a useful way to break those connections so you can...

The suggestion worked perfectly in SQL 2000.  Thanks for your help.

  Elliott

Yelena, Thanks for your tip.  Building the stored procedure right from QA works great and is very efficient.

Elliott

Thanks for your help.  I was unable to put any commands preceding the "Create Proc" command when writing the proc.  UNTIL I used Query Analyzer to edit the proc.  Then...

Tried that but error message says nothing can be written before the "Create Procedure" statement.

Elliott