Hi Loki,

Please try adding the "sqlservr.exe" to the exception list of Symantec.

I feel the date format of the servers differs. Please check it in "Control Panel --> Regional and language Options --> Customize --> Date".

I think I misread you question.

Please try using CONVERT as below.

select * from tbldeals

where CONVERT(VARCHAR(10),trade_date,111) = '2009/03/06'

Correct. Please try changing the compatibility level of the SQL 2005 database to "90".

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