In my code there is a DROP TABLE statement inside of a loop. When it runs, the tables are dropped (i.e., afterward they are no longer in the SYSTABLES table) but the underlying .tbl files are not deleted. When I issue the same DROP TABLE statements from the TSQL prompt, the files *are* deleted.
I thought that perhaps it's a permissions issue, but the user under which the code runs has "Full Control" permissions in the directory where the .tbl files reside.
Any ideas what I might be missing?
Thanks
I thought that perhaps it's a permissions issue, but the user under which the code runs has "Full Control" permissions in the directory where the .tbl files reside.
Any ideas what I might be missing?
Thanks