afh@ornl.gov (HUNTLEY JR A F) (04/12/91)
Attn: Sybase DBA's (Sun 4, especially), Sites running Sybase SQL Server on Sun4's should use caution with tables that contain text (and I think image, as well) datatype fields. If your SQL Server version is newer than mid-February (Sun4 Sybase EBF471 Feb 14 1991, or later) (select @@version to find out your version) do not drop or truncate tables that contain text/image datafields. If you do drop or truncate such tables, the space that had been allocated for text pages DOES NOT GET DEALLOCATED (sorry, I don't have the Sybase bug number yet) and there is no way to reclaim it other than: 1) a manual database rebuild on a new db allocation or 2) a Sybase Tech. Support dial-in session If you do a delete from the table BEFORE the drop/truncate table command then the text pages DO GET DEALLOCATED. This bug _may_ have been ported to some non-Sun4 post-February EBF's as well. They _expect_ to have another EBF to fix this situation in a month or so. Al Huntley (615) 576-7170 afh@ornl.gov