Thanks

yes, of course.

from the first (SQL 2000) to SQL server 2005

This is wonderful. Thank you for help. It works.

I don't want that. Is there easier way to do that.

Operating system is Microsoft Windows Server 2003 with no SevicePacks.

SQL Server is:  both Virtual Machines  - MSDE SP3

name                         secondname

network_name           secondname

status                         rpc,rpc out,use remote collation     

id                               0

sp_helpserver gives me SECONDNAME

I did only sp_dropserver 'FIRSTNAME'

and sp_addserver 'SECONDNAME', LOCAL.

Nothing else.

I wonder where serverproperty('servername') gather information

Yes I did.

After restart @@servername shows 'SECONDNAME', but

select serverproperty('servername') shows 'FIRSTNAME'. So, it must be written somewhere that 'FIRSTNAME'.

You mean there is no way standard login to be owner.

For example 'dts'. It must be windows user ?

thanks for suggestions.

I have another question about it. How could I create DTS package and standar login to be owner? I could connect to EM with any login, but when...

I asked 'if the folder is not shared', and I have only the name of folder (not full path)

great, that's it.

How to get drive name if folder is not shared ?

I think not