| Groups | Blog | Home |
sql server clients : Client for SQL Server 7.0
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 [quoted text, click to view] "aschrage16" <art.schrage@gmail.com> wrote in message news:1141139745.303817.76810@i40g2000cwc.googlegroups.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? >
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 [quoted text, click to view] "aschrage16" <art.schrage@gmail.com> wrote in message news:1141139745.303817.76810@i40g2000cwc.googlegroups.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? [quoted text, click to view] Andrew J. Kelly wrote:
> 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.googlegroups.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? > >
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 [quoted text, click to view] <aschrage16@yahoo.com> wrote in message news:1142264035.895114.18780@u72g2000cwu.googlegroups.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: >> 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.googlegroups.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? >> > >
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. [quoted text, click to view] Andrew J. Kelly wrote:
> 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.googlegroups.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: > >> 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.googlegroups.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? > >> > > >
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 [quoted text, click to view] <aschrage16@yahoo.com> wrote in message news:1142360307.440893.80110@i40g2000cwc.googlegroups.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: >> 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.googlegroups.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: >> >> 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.googlegroups.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? >> >> > >> > >
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 [quoted text, click to view] <aschrage16@yahoo.com> wrote in message news:1142442108.215232.323050@u72g2000cwu.googlegroups.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? >
Don't see what you're looking for? Try a search.
|
March 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |