Find size of a file

[Bell1991]

I am receiving a file and it could be empty.. How do i check the size of the file and if it is 0 then don't try to import in?

 

[mrdenny]

If you are using SQL 2000 you can use the extended stored procedure xp_getfiledetails to find this information. You can see some examples of how to use this procedure at

http://searchsqlserver.techtarget.c...17&ad=602771&asrc=EM_NLN_2129033&uid=2258499.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog