Client for SQL Server 7.0

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Are either of the programs below full featured clients for SQL Server
7.0? I am having difficulty reindexing my database for the first time--
i.e. I get no feedback from the server from a dbcc dbreindex command.
It appears that my syntax is correct:

DBCC DBREINDEX(tablename,'',85)

The statement above returns "OK" (no error), but it executes in 0
seconds and appears to do nothing. I have gotten the same result using
both of the following as a client:

MS Access 2003 (through a project)
Database Fishing Tool (http://daft.sourceforge.net/)

Is it that I don't have the right client or am I missing something
else?

.

Relevant Pages

  • Re: Reaching Access 2003 datas via SQL Server 2005 64 bits
    ... even with the procedure to create the invoice number I still ... One client enters in the store and asks for a product. ... formats of Access database files known as MDB and ACCDB and/or Access JET. ... (I have no problem to reach Sql Server 2005 tables from Microsoft ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: Quick Question on SQL Server 2005 Express
    ... you can't attach a database in a remote machine in your network as Andrew has already mantioned. ... One database can be used only by one SQL Server instance and as far as I understand the database in question is already attached to a SQL Server instance. ... Why not installing only SQL Server Management Studio and connect to your remote instance and perform actions this way? ... The Client can live anywhere as long as it has TCP access to the server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Permissions problem on SBS 2003 R2 for SQL Server 2005 clients
    ... use SQL Server authentication instead. ... I've been testing a SQL Server 2005 Express database in a multiuser ... environment using Window Small Business Server 2003 R2 with Windows XP ... On a given client computer to which I may have logged on with Windows ...
    (microsoft.public.windows.server.sbs)
  • Re: Quick Question on SQL Server 2005 Express
    ... I have not seen any documentation yet that states connecting other editions of SQL Server using SSMSE would break any license agreement. ... As Ekrem stated they should have a licensed edition of the full client tools and then all they have to do is register the server in the registered servers dialog and they should be all set. ... I have installed SQL Server 2005 Express, and now I want to connect to the remote database and use the Management Studio to manipulate the database. ...
    (microsoft.public.sqlserver.setup)