Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2007-01-24 : 15:27:57
|
| Hi,Is that possible to calculate Text File Bytes? I can do that using OSQL dir, and then loop through to get the exact data.But need to know if there is any predefined fuction to deal with this type of requirement?Thanks in advance to you all ;)SKR |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-24 : 23:14:10
|
You can make use of undocumented extended Stored Proc - xp_getfiledetails.EXEC master.dbo.xp_getfiledetails 'c:\test\test1.txt'GO Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2007-01-25 : 14:02:02
|
| Awesome..Thanks Harsh.SKR |
|
|
|
|
|
|
Calculate Text File bytes