Thank you Bru,

I saw this already but was concerned that it did not specifically say Windows Server 2003 R2 Enterprise x64. It just mentioned Windows Server 2003 Enterprise x64 and...

Thanks Michael,

Below is a copy of Books Online. I have bolded out some pointers to the fact that there are qualified and unqualified users During and After altering the database to restricted_user.

Thank you.

Jo

SINGLE_USER | RESTRICTED_USER...

Thanks Aaron

Thank you Aaron. I will try the Merant drivers.

Did you ever try the Openlink Lite Drivers?

Check and make sure that the connection on the database is not being altered during that time. I.e if the connection is being altered to restricted User mode, you may...

Thank you Cindy and Steve.

The Isolation level was not set. I have set it to Read Uncommited. I think this will do it.

Thanks

Jo

Thanks Steve,

Users are not running queries manually from Impromptu. Impromptu makes the queries based on the users request and so there is no way of modifying the input queries to...

Correct, I have

A --success--> B

|                     |

failure        failure      

|                     |

C                Copy of C

but if I previously compiled/executed A --Success-->B before adding C and Copy of c,

on adding C and copy of C,...

In the figure attached A,B,F1 and F2 are packages. On s = On Success and On f = On Failure.

If you build all the packages as shown in the figure...

Thanks Nicholas.

Is there a way one can add ON FAILURE sub-packages on already existing package and have then Execute when they are supposed to. I tried and mine did not Execute when...