Bob Muncie wrote:
> Michael Kuettner wrote:
>> Bob Muncie wrote:
>>> sandi wrote:
>>>> sf > wrote in
>>>>
>>>>> I don't use recipe software (too much trouble), but if I did I
>>>>> wouldn't spend any money on it - I'd use Gourmet Recipe
>>>>> Manager, which looks just like something you'd pay for.
>>>>> http://grecipe-manager.sourceforge.net/
>>>> Looks nice. Thanks.
>>> I downloaded it as it looked good also. Installed it, and imported a
>>> couple of 1000 recipe files from the meal-master web site. The
>>> application bombed, and when I submitted a bug report as it bombs when
>>> starting it up after that, the bug report was closed as a "duplicate"
>>> error, with a recommendation of removing the recipe.db file. But there
>>> is no recipe.db file. In XP, with SQL installed, it's sucked into the
>>> "master DB" (not a good thing). Other applications also use it. So to
>>> fix the problem, you'd have to remove SQL Server and re-install, which
>>> may very well break other applications you have installed that required
>>> SQL in the first place...
>>>
>> Nope. Just enlargen the database device for the master database.
>> Then drop the tables which don't belong into system.
>>
>>> I'm leaving the bloat in my DB. And deleting the Gtk tool kit needed as
>>> well as the Gourmet recipe manager.
>>>
>
> Thanks Michael.
>
> I have never done DB work with SQL, so I have no clue how to do what you
> make sound is so easy to do. If I did, I'd be happy to do it, as I did
> like the GRM application. The interface was pretty nice. But once I
> imported the MM recipes from the MM site, it brokededit. Uninstalling
> both it and the GTK tool kit didn't help. So yes, either edit the
> database (I have no skill there), or uninstall/re-install it, which
> would break other applications that were already using it.
>
Just get an SQL - shell.
Connect to the DB via ODBC or directly (ODBC - driver should already
be installed if the M$ - database runs).
Then run a script which should read something like :
"drop table where system.creation_date = <date of installation>
commit"
Look up the table names and fields in the system DB at the M$ site
(support.microsoft.com , AFAIR).
For playing around with databases, look up "database device" at the
M$ site. There you'll find the correct syntax for adding, mounting,
changing and removing DB - devices for M$ - SQL.

HTH.

Cheers,

Michael Kuettner