First, copy the filename PRJUtilsSQL2000.dll in the server, after register with REGSVR32, example:
REGSVR32 C:\WINDOWS\SYSTEM32\PRJUtilsSQL2000.dll

after execute the next code in SQL Query analyzer:


use master
GO

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO

if exists(select 1 from sysobjects where name='xp_getfiledetails')
drop procedure xp_getfiledetails
GO

create procedure xp_getfiledetails (@filename varchar(200))
AS
declare @nombre varchar(60),
@size int,
@creation_date varchar(10),
@creation_time varchar(10),
@last_written_date varchar(10),
@last_written_time int,
@last_accessed_date varchar(10),
@last_accessed_time int,
@attributes int

DECLARE @Object int
DECLARE @Hresult int
declare @ret int

EXEC @Hresult = sp_OACreate 'PRJUtilsSQL2000.clsUtilidades', @Object OUT;

EXEC @Hresult = sp_OAMethod @Object, 'xp_getfiledetails', @ret out, @filename

if @ret = 1
begin
EXEC @Hresult = sp_OAGetProperty @Object, 'Alternate_Name', @nombre OUT
EXEC @Hresult = sp_OAGetProperty @Object, 'Size', @size OUT
EXEC @Hresult = sp_OAGetProperty @Object, 'Creation_Date', @creation_date OUT
EXEC @Hresult = sp_OAGetProperty @Object, 'Creation_Time', @creation_time OUT
EXEC @Hresult = sp_OAGetProperty @Object, 'Last_Written_Date', @last_written_date OUT
EXEC @Hresult = sp_OAGetProperty @Object, 'Last_Written_Time', @last_written_time OUT
EXEC @Hresult = sp_OAGetProperty @Object, 'Last_Accessed_Date', @last_accessed_date OUT
EXEC @Hresult = sp_OAGetProperty @Object, 'Last_Accessed_Time', @last_accessed_time OUT
EXEC @Hresult = sp_OAGetProperty @Object, 'Attributes', @attributes OUT
select 'Alternate Name' = @nombre,
'Size' = @size,
'Creation Date' = @creation_date,
'Creation Time' = @creation_time,
'Last Written Date' = @last_written_date,
'Last Written Time' = @last_written_time,
'Last Accessed Date' = @last_accessed_date,
'Last Accessed Time' = @last_accessed_time,
'Attributes' = @attributes
end
else
print 'Archivo no existe, verifique por favor'


EXEC @Hresult = sp_OADestroy @Object


GO



Then we would have the store procedure in our environment SQL2005.

Greetings

P. The Souce Code of PRJUtilsSQL2000.dll and the file dll, can download from: http://www.fileserve.com/file/zv4TsBj