Need assistance restoring MS SQL 6.5 databases

We had a server running NT 4 and SQL 6.5, it was running an RMS database. We
attempted to move the databases to SQL 7.0 using the upgrade wizard and then
move them to SQL 2000 on another server. This all worked correctly, however
the client app that accesses the data cannot do so on the SQL 2000 box
(probably not compatible). So now we want to revert back to the old SQL 6.5
box however we can longer get SQL 6.5 to start, it is giving the error "
Cannot start SQL, cannot find the path specified'. Our next move was to build
a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
What we need is step by step instructions on how to accomplish this.
Alternatively, our first choice would be to restore the original server
however as stated we cannot get SQL 6.5 to start. Any assistance would be
appreciated
Hi,
With SQL 2000, set the database compatibility mode to SQL 6.5 and try your
application.
Execute the below command from query analyzer
sp_dbcmptlevel 'DBNAME',65
replace the dbname with actual.
If you still have issues then you can Install sql6.5 in Winnt and restore
from backup.
If you do not have backup then With DAT files you have use :-
Use the DISK REINIT and DISK REFIT commands.
Steps:-
1. Restart in Single-user mode
2. DISK REINIT and DISK REFIT against each device
3. Restart in normal mode
See books onlne for command syntax
Thanks
Hari
SQL Server MVP
"webby" <webby@.discussions.microsoft.com> wrote in message
news:6B14351A-B3E5-4130-8CBD-C16A5B80240A@.microsoft.com...
> We had a server running NT 4 and SQL 6.5, it was running an RMS database.
> We
> attempted to move the databases to SQL 7.0 using the upgrade wizard and
> then
> move them to SQL 2000 on another server. This all worked correctly,
> however
> the client app that accesses the data cannot do so on the SQL 2000 box
> (probably not compatible). So now we want to revert back to the old SQL
> 6.5
> box however we can longer get SQL 6.5 to start, it is giving the error "
> Cannot start SQL, cannot find the path specified'. Our next move was to
> build
> a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
> What we need is step by step instructions on how to accomplish this.
> Alternatively, our first choice would be to restore the original server
> however as stated we cannot get SQL 6.5 to start. Any assistance would be
> appreciated

Need assistance restoring MS SQL 6.5 databases

We had a server running NT 4 and SQL 6.5, it was running an RMS database. We
attempted to move the databases to SQL 7.0 using the upgrade wizard and then
move them to SQL 2000 on another server. This all worked correctly, however
the client app that accesses the data cannot do so on the SQL 2000 box
(probably not compatible). So now we want to revert back to the old SQL 6.5
box however we can longer get SQL 6.5 to start, it is giving the error "
Cannot start SQL, cannot find the path specified'. Our next move was to build
a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
What we need is step by step instructions on how to accomplish this.
Alternatively, our first choice would be to restore the original server
however as stated we cannot get SQL 6.5 to start. Any assistance would be
appreciated :)Hi,
With SQL 2000, set the database compatibility mode to SQL 6.5 and try your
application.
Execute the below command from query analyzer
sp_dbcmptlevel 'DBNAME',65
replace the dbname with actual.
If you still have issues then you can Install sql6.5 in Winnt and restore
from backup.
If you do not have backup then With DAT files you have use :-
Use the DISK REINIT and DISK REFIT commands.
Steps:-
1. Restart in Single-user mode
2. DISK REINIT and DISK REFIT against each device
3. Restart in normal mode
See books onlne for command syntax
Thanks
Hari
SQL Server MVP
"webby" <webby@.discussions.microsoft.com> wrote in message
news:6B14351A-B3E5-4130-8CBD-C16A5B80240A@.microsoft.com...
> We had a server running NT 4 and SQL 6.5, it was running an RMS database.
> We
> attempted to move the databases to SQL 7.0 using the upgrade wizard and
> then
> move them to SQL 2000 on another server. This all worked correctly,
> however
> the client app that accesses the data cannot do so on the SQL 2000 box
> (probably not compatible). So now we want to revert back to the old SQL
> 6.5
> box however we can longer get SQL 6.5 to start, it is giving the error "
> Cannot start SQL, cannot find the path specified'. Our next move was to
> build
> a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
> What we need is step by step instructions on how to accomplish this.
> Alternatively, our first choice would be to restore the original server
> however as stated we cannot get SQL 6.5 to start. Any assistance would be
> appreciated :)

Need assistance restoring MS SQL 6.5 databases

We had a server running NT 4 and SQL 6.5, it was running an RMS database. W
e
attempted to move the databases to SQL 7.0 using the upgrade wizard and then
move them to SQL 2000 on another server. This all worked correctly, however
the client app that accesses the data cannot do so on the SQL 2000 box
(probably not compatible). So now we want to revert back to the old SQL 6.5
box however we can longer get SQL 6.5 to start, it is giving the error "
Cannot start SQL, cannot find the path specified'. Our next move was to buil
d
a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
What we need is step by step instructions on how to accomplish this.
Alternatively, our first choice would be to restore the original server
however as stated we cannot get SQL 6.5 to start. Any assistance would be
appreciated Hi,
With SQL 2000, set the database compatibility mode to SQL 6.5 and try your
application.
Execute the below command from query analyzer
sp_dbcmptlevel 'DBNAME',65
replace the dbname with actual.
If you still have issues then you can Install sql6.5 in Winnt and restore
from backup.
If you do not have backup then With DAT files you have use :-
Use the DISK REINIT and DISK REFIT commands.
Steps:-
1. Restart in Single-user mode
2. DISK REINIT and DISK REFIT against each device
3. Restart in normal mode
See books onlne for command syntax
Thanks
Hari
SQL Server MVP
"webby" <webby@.discussions.microsoft.com> wrote in message
news:6B14351A-B3E5-4130-8CBD-C16A5B80240A@.microsoft.com...
> We had a server running NT 4 and SQL 6.5, it was running an RMS database.
> We
> attempted to move the databases to SQL 7.0 using the upgrade wizard and
> then
> move them to SQL 2000 on another server. This all worked correctly,
> however
> the client app that accesses the data cannot do so on the SQL 2000 box
> (probably not compatible). So now we want to revert back to the old SQL
> 6.5
> box however we can longer get SQL 6.5 to start, it is giving the error "
> Cannot start SQL, cannot find the path specified'. Our next move was to
> build
> a NT 4 box, install SQL 6.5 and attempt to restore, we have the .DAT file.
> What we need is step by step instructions on how to accomplish this.
> Alternatively, our first choice would be to restore the original server
> however as stated we cannot get SQL 6.5 to start. Any assistance would be
> appreciated

Need 2005 Wizard to create INSERT and UPDATE stored procedures.

In SQL Server 2000, the database wizard would create insert and update stored procedures for all of my tables.

I have a large SQL Server 2005 database with many tables and columns. I need wizard support to create insert and update stored procedures for them. Typing them all in manually is out of the question.

The 2005 Generate SQL Server Scripts Wizard does not create stored procuedure scripts. It only scripts tables.

Is there some other way to make Management Studio create stored procedure scripts the way Enterprise Manager did?

Are there any plans to restore this critical functionality that was left out of SQL Server 2005 and the service pack?

Do you know of any utilities that can fill this gap?

Any help would be appreciated.

Please file a suggestion for this functionality on http://connect.microsoft.com/sqlserver. We use customer feedback to prioritize future work. Suggestions and defect reports filed on the Connect site are placed directly into our internal issue tracking system so the appropriate team will see your request.

I don't think there is an easy way to do what you want using built-in functionality in SSMS. If you are comfortable writing .NET code, you could write a small Visual Basic or C# application using the SQL Management Objects to iterate through all your tables and generate the stored procedure code you need.

Thanks,
Steve