Yeah thats right, Registries are diffrent for diffrent verions.

But here my problem is different , I had posted the script which is for SQL Server 2000.

I have used cursors...

YEs, but in sysfiles current database file path is stored.

I require what we set in sql server properties--database settings tab-- default data path

And require both data and log file path(default)

I am doing scripting which will give default datapath of DATABASE files, in which i am already successfull. By executing following query we can get this:

declare @Datafile nvarchar(500), @LogFile nvarchar(500)

exec...