"Tom Moreau" wrote:

> What do you mean by " I added the SQL Server 2000 node into the SQL Server
> 2008 and run the
> reindexing." ?
>
> --
>    Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in message
> news:6281000C-3353-42FC-8E97-4AF2E97C4BA1@microsoft.com...
> Hi.
>
> I am using SQL Server 2000 EE (SP4) on Windows Server 2003 EE (SP2).
> Data is populated into the tables in bulk from text files through a third
> party application made in VB 6.
> The problem is that the data is not populating into the tables as I have
> done reindexing several times but all in vain. The problem starts when
> upgrade the RAM from 2GB to $GB and  installed the SQL Server 2008 EE on the
> same machine, on which SQL Server 2000 was already installed, as a
> standalone
> server. I added the SQL Server 2000 node into the SQL Server 2008 and run
> the
> reindexing.
>
> After that data is not populated into the tables and gives the error
> "Timeout expired". As I uninstalled SQL Server 2008 and also reinstalled SQL
> Server 2000 but the problem remains the same.
>
>
> Regards,
> Muhammad Bilal
>
>

"Tom Moreau" wrote:

> What do you mean by " I added the SQL Server 2000 node into the SQL Server
> 2008 and run the
> reindexing." ?
>
> --
>    Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in
> message
> news:6281000C-3353-42FC-8E97-4AF2E97C4BA1@microsoft.com...
> Hi.
>
> I am using SQL Server 2000 EE (SP4) on Windows Server 2003 EE (SP2).
> Data is populated into the tables in bulk from text files through a third
> party application made in VB 6.
> The problem is that the data is not populating into the tables as I have
> done reindexing several times but all in vain. The problem starts when
> upgrade the RAM from 2GB to $GB and  installed the SQL Server 2008 EE on
> the
> same machine, on which SQL Server 2000 was already installed, as a
> standalone
> server. I added the SQL Server 2000 node into the SQL Server 2008 and run
> the
> reindexing.
>
> After that data is not populated into the tables and gives the error
> "Timeout expired". As I uninstalled SQL Server 2008 and also reinstalled
> SQL
> Server 2000 but the problem remains the same.
>
>
> Regards,
> Muhammad Bilal
>
>

"Tom Moreau" wrote:

> Re-installing SQL Server is overkill.  Reindexing won't make the data
> appear.  Are you sure that the bulk load completed and wasn't rolled back?
> How are you selecting the data?  Use Query Analyzer (SQL 2000) or SSMS (SQL
> 2005 or 2008) and run a SELECT against the target table with the NOLOCK
> hint:
>
> select top 100
>     *
> from
>     MyTable with (nolock)
>
> .... will give you 100 rows from the table and will not block on locks.
>
>
> --
>    Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in message
> news:6C820BDC-6DC6-4D7A-A4AD-E7A8002543DE@microsoft.com...
> I mean that I only used sql server 2008 as a client to sql server 2000 and
> reindex the tables already in the sql server 2000.
>
> Regards,
> Muhammad Bilal
>
> "Tom Moreau" wrote:
>
> > What do you mean by " I added the SQL Server 2000 node into the SQL Server
> > 2008 and run the
> > reindexing." ?
> >
> > --
> >    Tom
> >
> > ----------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON   Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in
> > message
> > news:6281000C-3353-42FC-8E97-4AF2E97C4BA1@microsoft.com...
> > Hi.
> >
> > I am using SQL Server 2000 EE (SP4) on Windows Server 2003 EE (SP2).
> > Data is populated into the tables in bulk from text files through a third
> > party application made in VB 6.
> > The problem is that the data is not populating into the tables as I have
> > done reindexing several times but all in vain. The problem starts when
> > upgrade the RAM from 2GB to $GB and  installed the SQL Server 2008 EE on
> > the
> > same machine, on which SQL Server 2000 was already installed, as a
> > standalone
> > server. I added the SQL Server 2000 node into the SQL Server 2008 and run
> > the
> > reindexing.
> >
> > After that data is not populated into the tables and gives the error
> > "Timeout expired". As I uninstalled SQL Server 2008 and also reinstalled
> > SQL
> > Server 2000 but the problem remains the same.
> >
> >
> > Regards,
> > Muhammad Bilal
> >
> >
>
>

"Tom Moreau" wrote:

> Re-installing SQL Server is overkill.  Reindexing won't make the data
> appear.  Are you sure that the bulk load completed and wasn't rolled back?
> How are you selecting the data?  Use Query Analyzer (SQL 2000) or SSMS
> (SQL
> 2005 or 2008) and run a SELECT against the target table with the NOLOCK
> hint:
>
> select top 100
>     *
> from
>     MyTable with (nolock)
>
> .... will give you 100 rows from the table and will not block on locks.
>
>
> --
>    Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in
> message
> news:6C820BDC-6DC6-4D7A-A4AD-E7A8002543DE@microsoft.com...
> I mean that I only used sql server 2008 as a client to sql server 2000 and
> reindex the tables already in the sql server 2000.
>
> Regards,
> Muhammad Bilal
>
> "Tom Moreau" wrote:
>
> > What do you mean by " I added the SQL Server 2000 node into the SQL
> > Server
> > 2008 and run the
> > reindexing." ?
> >
> > --
> >    Tom
> >
> > ----------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON   Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in
> > message
> > news:6281000C-3353-42FC-8E97-4AF2E97C4BA1@microsoft.com...
> > Hi.
> >
> > I am using SQL Server 2000 EE (SP4) on Windows Server 2003 EE (SP2).
> > Data is populated into the tables in bulk from text files through a
> > third
> > party application made in VB 6.
> > The problem is that the data is not populating into the tables as I have
> > done reindexing several times but all in vain. The problem starts when
> > upgrade the RAM from 2GB to $GB and  installed the SQL Server 2008 EE on
> > the
> > same machine, on which SQL Server 2000 was already installed, as a
> > standalone
> > server. I added the SQL Server 2000 node into the SQL Server 2008 and
> > run
> > the
> > reindexing.
> >
> > After that data is not populated into the tables and gives the error
> > "Timeout expired". As I uninstalled SQL Server 2008 and also reinstalled
> > SQL
> > Server 2000 but the problem remains the same.
> >
> >
> > Regards,
> > Muhammad Bilal
> >
> >
>
>

"Tom Moreau" wrote:

> What tool are you using when you get teh timeout?  Have you tried increasing
> the timeout setting?
>
> --
>    Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in message
> news:B861AD6F-0BA6-410C-B518-17C38B4D681A@microsoft.com...
> Data is inserted after comparing the each record inserted in the table with
> the rows in another lookup table. Profiler shows the Query “Select * from
> the
> tbl_Lookup” and then cursor close and the error message of “timeout expired”
> is displayed.
>
> Before this problem  after showing the “Select * from the tbl_Lookup” the
> SQL Server starts populating the data.
>
> Is there any other way or steps to increase the efficiency of the SQL Server
> other than reindexing. Or any maintenance plan to improve the efficiency of
> the SQL Server which should be done periodically.
>
>
>
> Regards,
> Muhammad Bilal
>
> "Tom Moreau" wrote:
>
> > Re-installing SQL Server is overkill.  Reindexing won't make the data
> > appear.  Are you sure that the bulk load completed and wasn't rolled back?
> > How are you selecting the data?  Use Query Analyzer (SQL 2000) or SSMS
> > (SQL
> > 2005 or 2008) and run a SELECT against the target table with the NOLOCK
> > hint:
> >
> > select top 100
> >     *
> > from
> >     MyTable with (nolock)
> >
> > .... will give you 100 rows from the table and will not block on locks.
> >
> >
> > --
> >    Tom
> >
> > ----------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON   Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in
> > message
> > news:6C820BDC-6DC6-4D7A-A4AD-E7A8002543DE@microsoft.com...
> > I mean that I only used sql server 2008 as a client to sql server 2000 and
> > reindex the tables already in the sql server 2000.
> >
> > Regards,
> > Muhammad Bilal
> >
> > "Tom Moreau" wrote:
> >
> > > What do you mean by " I added the SQL Server 2000 node into the SQL
> > > Server
> > > 2008 and run the
> > > reindexing." ?
> > >
> > > --
> > >    Tom
> > >
> > > ----------------------------------------------------
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > SQL Server MVP
> > > Toronto, ON   Canada
> > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > >
> > >
> > > "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in
> > > message
> > > news:6281000C-3353-42FC-8E97-4AF2E97C4BA1@microsoft.com...
> > > Hi.
> > >
> > > I am using SQL Server 2000 EE (SP4) on Windows Server 2003 EE (SP2).
> > > Data is populated into the tables in bulk from text files through a
> > > third
> > > party application made in VB 6.
> > > The problem is that the data is not populating into the tables as I have
> > > done reindexing several times but all in vain. The problem starts when
> > > upgrade the RAM from 2GB to $GB and  installed the SQL Server 2008 EE on
> > > the
> > > same machine, on which SQL Server 2000 was already installed, as a
> > > standalone
> > > server. I added the SQL Server 2000 node into the SQL Server 2008 and
> > > run
> > > the
> > > reindexing.
> > >
> > > After that data is not populated into the tables and gives the error
> > > "Timeout expired". As I uninstalled SQL Server 2008 and also reinstalled
> > > SQL
> > > Server 2000 but the problem remains the same.
> > >
> > >
> > > Regards,
> > > Muhammad Bilal
> > >
> > >
> >
> >
>
>

"Tom Moreau" wrote:

> What tool are you using when you get teh timeout?  Have you tried
> increasing
> the timeout setting?
>
> --
>    Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in
> message
> news:B861AD6F-0BA6-410C-B518-17C38B4D681A@microsoft.com...
> Data is inserted after comparing the each record inserted in the table
> with
> the rows in another lookup table. Profiler shows the Query “Select * from
> the
> tbl_Lookup” and then cursor close and the error message of “timeout
> expired”
> is displayed.
>
> Before this problem  after showing the “Select * from the tbl_Lookup” the
> SQL Server starts populating the data.
>
> Is there any other way or steps to increase the efficiency of the SQL
> Server
> other than reindexing. Or any maintenance plan to improve the efficiency
> of
> the SQL Server which should be done periodically.
>
>
>
> Regards,
> Muhammad Bilal
>
> "Tom Moreau" wrote:
>
> > Re-installing SQL Server is overkill.  Reindexing won't make the data
> > appear.  Are you sure that the bulk load completed and wasn't rolled
> > back?
> > How are you selecting the data?  Use Query Analyzer (SQL 2000) or SSMS
> > (SQL
> > 2005 or 2008) and run a SELECT against the target table with the NOLOCK
> > hint:
> >
> > select top 100
> >     *
> > from
> >     MyTable with (nolock)
> >
> > .... will give you 100 rows from the table and will not block on locks.
> >
> >
> > --
> >    Tom
> >
> > ----------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON   Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in
> > message
> > news:6C820BDC-6DC6-4D7A-A4AD-E7A8002543DE@microsoft.com...
> > I mean that I only used sql server 2008 as a client to sql server 2000
> > and
> > reindex the tables already in the sql server 2000.
> >
> > Regards,
> > Muhammad Bilal
> >
> > "Tom Moreau" wrote:
> >
> > > What do you mean by " I added the SQL Server 2000 node into the SQL
> > > Server
> > > 2008 and run the
> > > reindexing." ?
> > >
> > > --
> > >    Tom
> > >
> > > ----------------------------------------------------
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > > SQL Server MVP
> > > Toronto, ON   Canada
> > > https://mvp.support.microsoft.com/profile/Tom.Moreau
> > >
> > >
> > > "Muhammad Bilal" <MuhammadBi***@discussions.microsoft.com> wrote in
> > > message
> > > news:6281000C-3353-42FC-8E97-4AF2E97C4BA1@microsoft.com...
> > > Hi.
> > >
> > > I am using SQL Server 2000 EE (SP4) on Windows Server 2003 EE (SP2).
> > > Data is populated into the tables in bulk from text files through a
> > > third
> > > party application made in VB 6.
> > > The problem is that the data is not populating into the tables as I
> > > have
> > > done reindexing several times but all in vain. The problem starts when
> > > upgrade the RAM from 2GB to $GB and  installed the SQL Server 2008 EE
> > > on
> > > the
> > > same machine, on which SQL Server 2000 was already installed, as a
> > > standalone
> > > server. I added the SQL Server 2000 node into the SQL Server 2008 and
> > > run
> > > the
> > > reindexing.
> > >
> > > After that data is not populated into the tables and gives the error
> > > "Timeout expired". As I uninstalled SQL Server 2008 and also
> > > reinstalled
> > > SQL
> > > Server 2000 but the problem remains the same.
> > >
> > >
> > > Regards,
> > > Muhammad Bilal
> > >
> > >
> >
> >
>
>