I cannot use xp_filesize because the i cannot make use of xpFileUtil.dll file into the sql server version which I am using. this is the restriction which has been put on me for the development. The reason which i can think of is that you need to pay some $ to access that dll.

This is the only reason which i can think of for restriction of the using xpFileUtil.dll.

so now can you please help me for the same.