FILEPROPERTY 'SpaceUsed' what it returns

Question

Post reply

FILEPROPERTY 'SpaceUsed' what it returns

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SrcName Default port Points: 1460 More actions · Answer 1

look at this useful link

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

dmoldovan SSCertifiable Points: 6334 More actions · Answer 2

According to TechNet, FILEPROPERTY

"returns the specified file name property value when a file name in the current database and a property name are specified. Returns NULL for files that are not in the current database."

http://technet.microsoft.com/en-us/library/ms188401%28v=sql.105%29.aspx