Client for SQL Server 7.0

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?
How many indexes do you have on this table?
SQL Query Analyzer (comes with SQL 7) is sufficient to run this command.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"aschrage16" <art.schrage@.gmail.com> wrote in message
news:1141139745.303817.76810@.i40g2000cwc.googlegro ups.com...
> 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?
>
|||What does the output of DBCC SHOWCONTIG(tablename) show?
Andrew J. Kelly SQL MVP
"aschrage16" <art.schrage@.gmail.com> wrote in message
news:1141139745.303817.76810@.i40g2000cwc.googlegro ups.com...
> 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?
>
|||That's what's led me through this search for a client. I have
repeatedly tried to run DBCC commands of several types (including DBCC
SHOWCONTIG, DBCC DBREINDEX, etc.) and I get no output back unless there
is an error in the syntax. Is there perhaps a setting somewhere in SQL
Server 7 that's hiding the output or something?
Andrew J. Kelly wrote:[vbcol=seagreen]
> What does the output of DBCC SHOWCONTIG(tablename) show?
> --
> Andrew J. Kelly SQL MVP
>
> "aschrage16" <art.schrage@.gmail.com> wrote in message
> news:1141139745.303817.76810@.i40g2000cwc.googlegro ups.com...
|||Have you tried using Query Analyzer or oSql? You may want to try and add
SET NOCOUNT ON before the DBCC command and send them as a batch.
Andrew J. Kelly SQL MVP
<aschrage16@.yahoo.com> wrote in message
news:1142264035.895114.18780@.u72g2000cwu.googlegro ups.com...
> That's what's led me through this search for a client. I have
> repeatedly tried to run DBCC commands of several types (including DBCC
> SHOWCONTIG, DBCC DBREINDEX, etc.) and I get no output back unless there
> is an error in the syntax. Is there perhaps a setting somewhere in SQL
> Server 7 that's hiding the output or something?
>
> Andrew J. Kelly wrote:
>
|||I tried SET NOCOUNT ON and sent it as a batch with the DBCC command...
no luck. I do not own SQL SERVER myself, but I asked my ISP to run the
following DBCC statement in Query Analyzer:
dbcc dbreindex('tablename','',85)
Here's the response he got from SQL Server:
28-Feb-2006 05:25:23
RUN took 0.0 seconds.
<c1>: OK.
This is the same response I got through my client and its the same
response I get from all DBCC commands. Takes 0.0 seconds and no output.
Andrew J. Kelly wrote:[vbcol=seagreen]
> Have you tried using Query Analyzer or oSql? You may want to try and add
> SET NOCOUNT ON before the DBCC command and send them as a batch.
> --
> Andrew J. Kelly SQL MVP
>
> <aschrage16@.yahoo.com> wrote in message
> news:1142264035.895114.18780@.u72g2000cwu.googlegro ups.com...
|||Ok, I tried oSql (actually sqlcmd) and I got output from dbcc
showcontig. I wonder what the deal is with the client programs I have
been using? Do you know where to get one that actually works? sqlcmd
seems to work, but its kind of cumbersome. Unfortunately, I don't own a
copy of SQL Server... I just want to remotely manage the SQL database
that is hosted by my ISP.
|||That output does not look like it is from QA. But one thing to note. If
you do not have a Clustered index on the table a reindex will not have
anything to do since it can not defragment a HEAP. Do you have a clustered
index?
Andrew J. Kelly SQL MVP
<aschrage16@.yahoo.com> wrote in message
news:1142360307.440893.80110@.i40g2000cwc.googlegro ups.com...
>I tried SET NOCOUNT ON and sent it as a batch with the DBCC command...
> no luck. I do not own SQL SERVER myself, but I asked my ISP to run the
> following DBCC statement in Query Analyzer:
> dbcc dbreindex('tablename','',85)
> Here's the response he got from SQL Server:
> --
> 28-Feb-2006 05:25:23
> RUN took 0.0 seconds.
> <c1>: OK.
> --
> This is the same response I got through my client and its the same
> response I get from all DBCC commands. Takes 0.0 seconds and no output.
>
> Andrew J. Kelly wrote:
>
|||The output was actually from the client I was using, but my ISP said
they got "the same thing", which I guess meant no output, or "OK" or
something.
I don't have a clustered index (I don't think). So that would make
sense then. Is DBCC INDEXDEFRAG meaningless then too?
|||Yes it is. If you have nonclustered indexes then you can run either on them
but you need to specify the index name. It will do nothing for the data
itself though. For that you need a clustered index. It is highly recommended
that every table have a clustered index and a Primary Key but any one of the
indexes or constraints can be clustered..
Andrew J. Kelly SQL MVP
<aschrage16@.yahoo.com> wrote in message
news:1142442108.215232.323050@.u72g2000cwu.googlegr oups.com...
> The output was actually from the client I was using, but my ISP said
> they got "the same thing", which I guess meant no output, or "OK" or
> something.
> I don't have a clustered index (I don't think). So that would make
> sense then. Is DBCC INDEXDEFRAG meaningless then too?
>