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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-08-19 : 10:33:17
|
| I have a bit of a weird one. Don't know if anyone can help.I have a view that returns 5 401 886 records - 3 guid columns & a tinyint.When I try and BCP it to disk using:declare @SQL varchar(300)Set @SQL='exec master..xp_cmdshell ''bcp "SELECT * FROM myDB.dbo.vw_HistoryLinksMore " queryout E:\Network\HisLinksMore.txt -t¦¦\t -r¦¦\n -c -Usa -Pmypword'''Exec(@SQL)GOit carries on for ever. HisLinksMore.txt keeps growing and growing until there is no space left on the hardrive. I'm talking 30 gig's worth of space gone - thanks to this one txt file.I've done the sums (maybe incorrectly) and I can't work out why this bcp out file should be getting so big.Any ideas anyone? |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-08-19 : 10:43:40
|
| not to worry,not happening now |
 |
|
|
|
|
|
BCP chomp up harddrive