Please check whether all the data existed in 2000 has been restored or not (Do a Select count(*) from Table).

Also check the database compatibility level is 90.

EXEC sp_dbcmptlevel 'pubs', 90

...

It does not.

You can find it here

Please try starting the SQL Server manually by using some of the parameters explained here

" sp_who2 active " will give you details of the active transactions on a given instance

I feel that there must be a FULL backup taken between the 1st and the 7th day. Please check the Backup History tables in MSDB to verify the same. The...

Which edition of SQL Server 2008 are you using?

Both look good. I feel GetDate() would be more apt.

Hi Ansar,

The error message that you got during install is related to the XPs used by SQL Server Agent. You can turn it on by issuing the following commands.

sp_configure...

Mani (8/31/2008)

---

Yeah Samule,

How to manually change the sample password to something complex in the instmsdb.sql..

I did not understand where to find instmsdb.sql..?and do we need change this before installation.?...

Please check whether the user has been explicitly denied access on the Functions

You can find more information here

I got it from querying the sysobjects table in master.

"...

Hi Shine,

Looks like the Service Principal Name (SPN) for SQL Server is missing. I feel instead of the the server name, if you use localhost\InstanceName or .\Instance name, the package...

Thanks. Its mine