Checkout the link..........

http://rais.ornl.gov/homepage/tm/tm117.pdf

Oh,,.................great

Mansoor,

The database you are tying to connect in an sql2000 DB server.......Then how can you change the compatibility level to 90........

For your clarification use this ........."select @@version"

The Windows Event Logs on any server can provide insight to potential and real problems. As a SQL Server Database

Administrator, it is important to have knowledge of problems that exist...

The account that sql runs as needs to have the security privlege to access the directory or file.

🙂

And the error resembles so

OH thats correct krishna............i'm also having a doubt whether he is trying to do it on sql2000

Sorry..............the reply above was totally by mistake

Use sp_dbcmptlevel

EXEC dbo.sp_dbcmptlevel @dbname=N'PUBS', @new_cmptlevel=90

Hi,

Check these

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

http://support.microsoft.com/kb/889646

To resolve this issue, you must add an account to the Database Creators role and to the Security Administrators role in SQL Server. You add the account that...

What happened ratheesh...........is google not available der

For details about lazy writer and checkpoint refer this

http://sqlserverpedia.com/wiki/Memory_-_Lazy_Writer_and_Checkpoint

http://msdn.microsoft.com/en-us/library/ms188748.aspx

And for details about ACID properties ref :

http://msdn.microsoft.com/en-us/library/aa480356.aspx

http://www.allinterview.com/showanswers/13096.html

thnks ken

What you seem to have is a problem where the record is acceptable in one database but not theother. Suggest you look at the differnces between the two database structures...