Yeah, I saw that.. My sql is rusty so I didn’t want to take a chance on deleting everything..
Better to spend some time getting back up to speed and writing the delete function where I can delete just the row's I want too as I will need it anyway.. I was expecting something along the lines of query analyzer or enterprise analyzer...whatever it was called. Don't remember the name as I havent seen it since 2002 Maybe I need to contract you out to handle the DBA stuff <grin> Virgil Bierschwale http://www.virgilslist.com http://www.tccutlery.com http://www.bierschwale.com http://www.bierschwalesolutions.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen the Cook Sent: Friday, December 22, 2006 7:01 PM To: 'ProFox Email List' Subject: RE: [NF] SQL Server shareware Virgil Bierschwale <> wrote: > Added through the control panel.. > They had a button for doing so.. Well I got to my db on GoDaddy. I go in through the connection interface that they offer, because you can't manage it from outside of their interface using a management tool. I have the query analyzer page open, and this is it's text. Hahaha it's funny isn't it? myLittleTree SQL Web Admin myLittleTree :: spacingClick to expand or reduce. myLittleTree Connection myLittleTree :: spacingmyLittleTree :: line myLittleTree Connection myLittleTree :: spacingmyLittleTree :: line myLittleTree Disconnect myLittleTree :: spacingClick to expand or reduce. myLittleTree whsql-v08 myLittleTree :: spacingmyLittleTree :: lineClick to expand or reduce. myLittleTree Databases myLittleTree :: spacingmyLittleTree :: linemyLittleTree :: lineClick to expand or reduce. myLittleTree DB_106184 myLittleTree :: spacingmyLittleTree :: linemyLittleTree :: linemyLittleTree :: spacing myLittleTree Tables myLittleTree :: spacingmyLittleTree :: linemyLittleTree :: linemyLittleTree :: spacing myLittleTree Views myLittleTree :: spacingmyLittleTree :: linemyLittleTree :: linemyLittleTree :: spacing myLittleTree Stored Procedures myLittleTree :: spacingmyLittleTree :: lineClick to expand or reduce. myLittleTree Tools myLittleTree :: spacingmyLittleTree :: linemyLittleTree :: spacing myLittleTree Query Analyser myLittleTree :: spacingmyLittleTree :: linemyLittleTree :: spacing myLittleTree Generate INSERT scripts myLittleTree :: spacingmyLittleTree :: linemyLittleTree :: spacing myLittleTree CSV import wizard myLittleTree :: spacingClick to expand or reduce. myLittleTree Preferences Do you see the myLittleTree for the query Analyzer? If you click on that in a tree view, it opens up a QA page that you can type any SQL command and execute. Were you expecting to see data in a table like FP? Where you can click on it and it's marked for deletion when you pack? Anyway you can execute code like.... Delete myTable Where myKey <= 50 Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.26/598 - Release Date: 12/22/2006 3:22 PM [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
