This link will give you a template on how you can proceed with your VB code with a SQL stored procedure

http://support.microsoft.com/kb/q146651/

What application is the macro? Are you talking about Visual Basic macros?

Jim,

Check one more place...in Studio manager Security/Credentials

Do you see your Proxy user underneath this folder?

Are the jobs using the SQL 2000 Database Maintenance Plan wizard or the new SQL 2005 Integration Services (SSIS)

Prakash

Thank you! the double variable was it..I altered the script to declare test, put the SET in the cursor loop and all works well!!

Thanks but I cannot do that...I am not giving you all the information but the top of the query declares all the tablenames from a given database via a cursor.

So...

thanks for the help that works...(and simple) you can tell it is Monday for me.

Jim,

Had the same problem this is what I did and you need to check:

1. Proxy Users is shown Under SQL Server Agent/Proxies/Operating System

2. Under General properties of that agent make...

Never mind resolved it...stopped and restarted the Windows Management Instrumentation service and now up and running!

I got this figured out and wanted to share. It seems (shocker here) that the Microsoft Article I referenced and what is in SQL 2005 BOL are conflicting.

Using Setting...

Nope you do not need to be on Enterprise Edition to recover to point of failure

Enterprise

Standard

Development

Workgroup (I think)

all have point of failure

arj,

To answer your question on the Compatibility level, the answer is 'it depends' what does this database do? For example for me, we migrated our ERP system from SQL...

You indicate that the users in the groups have full rights to the actual drives (E and F) but what are the rights of these four groups in the SQL...

Great!!! Glad to hear it!!:D

To play it safe let the emergency mode continue..

In the answer of putting the database back online if this is a database that has a front-end application that you can...