SQL 7.0 sp2 -need help urgently

SQL 7.0 sp2 -need help urgently

Post by geetamadur.. » Tue, 18 Jul 2000 04:00:00



I am currently using SQL7.0 with sp1.How far will I be benefitted with
sp2?what r the implications?WIll i have to shut down the production
server?
Also I needed the site where I could get some information about sp2.

Pl help.
Thanks in advance
Geeta

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 

SQL 7.0 sp2 -need help urgently

Post by Shawn Clar » Tue, 18 Jul 2000 04:00:00


Geeta,

The best thing to do is read the KB article on SP2 to see if you will
benefit from it. Most likely you will need to reboot your server but I have
had one machine where I didn't need to reboot it after applying the SP2. Not
sure why it didn't need it. All my other servers needed reboots.

Head to the Microsoft SQL Server 7.0 Service Pack 2 web page for a link to
the KB article.
http://www.microsoft.com/sql/downloads/sp2.htm

--
Shawn Clark
Senior Software Consultant
Meridian Technology Group


Quote:> I am currently using SQL7.0 with sp1.How far will I be benefitted with
> sp2?what r the implications?WIll i have to shut down the production
> server?
> Also I needed the site where I could get some information about sp2.

> Pl help.
> Thanks in advance
> Geeta

> Sent via Deja.com http://www.deja.com/
> Before you buy.


 
 
 

SQL 7.0 sp2 -need help urgently

Post by geetamadur.. » Tue, 18 Jul 2000 04:00:00


Thanks Shawn!Appreciate that!



> Geeta,

> The best thing to do is read the KB article on SP2 to see if you will
> benefit from it. Most likely you will need to reboot your server but
I have
> had one machine where I didn't need to reboot it after applying the
SP2. Not
> sure why it didn't need it. All my other servers needed reboots.

> Head to the Microsoft SQL Server 7.0 Service Pack 2 web page for a
link to
> the KB article.
> http://www.microsoft.com/sql/downloads/sp2.htm

> --
> Shawn Clark
> Senior Software Consultant
> Meridian Technology Group



> > I am currently using SQL7.0 with sp1.How far will I be benefitted
with
> > sp2?what r the implications?WIll i have to shut down the production
> > server?
> > Also I needed the site where I could get some information about sp2.

> > Pl help.
> > Thanks in advance
> > Geeta

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy.
 
 
 

1. Help needed: Centura SQLBASE 7.50 to MS-SQL 7.0 SP2 via DTS

can anyone help ???
were trying to import from centura sqlbase 7.5 to ms-sql 7.0.
when importing via Data Transformation Service (DTS) the DTS connects first
via ODBC to SQLBASE and then via direct connect to a local MS-SQL Database.
Then DTS creates the first table selected without any problems. After that
the DTS seems to drop the odbc connection and no data can be transferred. If
selecting more than one table the dts hangs after creating the first table
and trying to create the second table.
Weve been trying this with the following ODBC Drivers:
Centura SQLBase 3.01 32-bit Driver -NT & Win95 Version 3.01.00.06 and
Centura SqlBase 3.5 32-bit Driver -NT & Win95 Version 3.50.00.000. Importing
from Datasources other than Centura via ODBC seems to work fine.Scince we
are willing to migrate our front end application to use both sql servers it
would be very important for us to fully import our existing database into
ms-sql. please help anyone !!!
thx in advance

P.Piechutzki

Very firm in SQLBASE, Powerbuilder and fairly firm in MS-SQL.

2. Serial numbers

3. URGENTLY NEED HELP : Can NOT established (SQL server crashed)

4. Unique Constraint & Unique Index

5. help needed urgently for a sql 7/0 job

6. Error creating sp_addmergearticle

7. SQL-Merge Tables, Help needed urgently

8. ReportSmith Error Messages - Help!

9. Urgently need help from a SQL black belt

10. SQL Server Rollback - Urgently Need Help

11. SQL....Pls Help!! Urgently Needed

12. Help Needed Urgently - Newbie Q of a simple SQL Query

13. sql query, help needed urgently, please