declare @return        int 
declare @fso           int
declare @fso_file      int
declare @fso_file_size int
declare @Filename varchar(1000)

-- Create File SystemObject
execute @return = sp_OACreate
	'Scripting.FileSystemObject',
	@fso    output

select @Filename = 'c:\winnt\explorer.exe'

-- Create File Object
execute @return = sp_OAMethod
	@fso,
	'GetFile',
	@fso_file    output,
	@Filename

-- Get File Size
execute @return = sp_OAGetProperty
	@fso_file,
	'Size',
	@fso_file_size    output

-- Dispaly file size
select file_size = @fso_file_size

-- Create directory command
select @Filename = 'dir '+@Filename

-- Use command shell to get file size with directory command to verify
exec master.dbo.xp_cmdshell @Filename