Results 1 to 2 of 2

Thread: [RESOLVED] Deleting unused tables in SQL Server Database

  1. Mar 28th, 2008, 10:21 AM #1
    luta
    luta is offline

    Thread Starter
    Junior Member
    Join Date
    Oct 2007
    Posts
    27

    Resolved [RESOLVED] Deleting unused tables in SQL Server Database

    Hi,

    I have a SQL Server 2000 Database which I need to deleted some 20 + tables which are no longer needed.
    My question is once I delete those tables is there anything else taht I need to do to recover some of the free space from the deleted tables (Shrink database?)

    Thank you

    luta
    Reply With Quote Reply With Quote
  2. Mar 29th, 2008, 01:31 PM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Deleting unused tables in SQL Server Database

    DBCC SHRINKDATABASE
    http://msdn2.microsoft.com/en-us/library/aa258287.aspx

    autoshrink
    http://support.microsoft.com/default.aspx/kb/315512
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width