In SQL 2000 you can use Enterprise Manager and Query Analyzer. In SQL 2005, SQL Server Management Studio.


>I've been using Sql Server now for about 2-3 months and I miss the VFP command window terribly !!
>
>Anybobody know of any utility around whch emulates the VFP window in Dot Net, or even in VFP allows access to a Sql Server file using Command Window type commands.
>The likes of Brow fields , Delete all for a=b, replace all rep with "003" for State = 'NY' , Copy to ANOTHER Table for x=y etc etc etc
>Its very frustrating trying to do little tweaky changes like this..... I am currently taking a copy of the Sql Server off line, writing a special .prg in VFP to do any changes, and Restoring back the Database when finished.
>
>I thought I saw someting a while ago that did this sort of thing... I am aware of the VFP toolkit but I dont think it does this sort of thing.
>
>Any help appreciated.
>regards,
>Gerard