November 15, 2004 at 5:35 pm
I am using VB6 with a MSDE backend
How do I compact the database, preferably in VB code or SQL, failing that with an utility?
Thanks
November 17, 2004 at 2:23 am
Hey,
Are you familiar with SQL DMO Libraries ? you can do all the actions of SQL EM using sqldmo libraries. i dont have any code base for the same. just have a look at this COM and if you are facing any probs let me know.
Jeswanth
--------------------------------
November 17, 2004 at 3:07 am
What Com?
November 17, 2004 at 3:13 am
I was refering to the DMO its a Com Library . that you can find under the references of VB . its named as Microsoft SQLDMO Object Library. this Component contains the Functions whichcan be used to perform all actions that can be done in SQL server Enteprise Manager. Pls check out more information is SQL Server Books Online or WEB you will get lot of information. and its pretty simple.
have look at it mean while let me check out the Classes in that
--------------------------------
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply