>Which is a best way to use the table. Aviod message Alies is already use
>thanks
IF NOT USED("YourTable")
USE YourTable IN 0 SHARED AGAIN
ENDIF
SELECT YourTable
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.