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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-17 : 07:38:59
|
| Bill writes "How do I supress verbose messaging out of xp_fileexist. The fact that one line was affected does not interest me, I just want to know if the file was found or not. SQL Server 2000 w/Win2000.Here's the code and result:exec master..xp_fileexist @filename, @cmd_ret outif @cmd_ret = 1 begin set @onfile = @onfile +1 --print '** On File **: ' + @filename endelse begin set @missing = @missing +1 print '** Missing **: ' + @filename end(1 row(s) affected)(1 row(s) affected)** Missing **: \\dev01\MAPS\file1.pcx(1 row(s) affected)(1 row(s) affected)" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-17 : 07:39:16
|
| SET NOCOUNT ON |
 |
|
|
|
|
|
xp_fileexist