I still have problems to copy DB to SQL2K.

The view package log error description is as follows:

Step Error Source: Microsoft Data Transformation Services [DTS] Package

Step Error Description: Unspecified error

Step...

I am administrator of local and domain on both the source and destination server.

I didn't shut down SQL7 When I copied the DB.

So maybe some users entered data while I...

Yes, changing from SQL7 standard to SQL2K Enterprise.

It is enough to display a resord set ( A number of rows).

Based on the discussions before, I wrote a SP, which uses a cursor loop, pass table name as...

Hi,

According to your instructions, I wrote a script to count the rows added within a given time period. The script works successfully. But I can't see the result.

Would you tell...

Great idea. I am going to try it.

Thanks

Thanks for your reply. The script works very well.

But I have 250 tables, and the script just tells me the number of rows added within some day(s).

Do you...

Both ways work well.

Thank you very much!

I tried to update sysdatabases for model.The following is my script:

USE master

GO

RESTORE DATABASE master

FROM DISK = 'C:\backup\master\master.bak'

WITH REPLACE

EXEC sp_configure 'allow updates', '1'

RECONFIGURE WITH OVERRIDE

UPDATE sysdatabases

SET filename = 'C:\MSSQL7\DATA\model.mdf'

WHERE ...

I asked a stupid question, because Edwin Blackwood almost answered my question.

I did restore master successfully. Then I restart the server. But I can't restart SQL Server. The log file...

I appreciate everybody.

Your instructions are right. I did restore master from our backup. However, I come cross new problems.

After restored master, I can't make connection to SQL Server...

Our production site hosts SQL Server and web-based applications. My boss asked me to setup

another server by restoring SQL Server and applications from our backups.

I have no experience at all....