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 |
|
jerome
Starting Member
1 Post |
 Posted - 2011-03-10 : 08:05:02
|
| Hi master,can u give me the code to find the size of the file. Let me explain clearly.I want the sql job to find the size of the file.And it should check the size, if it is 0 bytes means it should fail. and send a mail. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-03-10 : 08:06:33
|
use xp_cmdshell and issue a DIR on the path \ file
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
How to find the size of the text file