>You could do a SELECT 0 before the create table.
>
>USED('tablealias') will let you see if a table is open.
>
But only if you use the right alias. I'm maintaining an app where, as originally written, different modules used the same table with 3 different aliases.
Regards,
Jim