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-11-09 : 07:05:22
|
| writes "Hi,I am new to this forum. I have a small query. I have a database where daily transaction is around 20k at least. I want run a bulk copy program (Stored Procedure), which will read data from text file. The size of the text file is around 4 to 5 mb. My question is does BCP will take too much of sql server resource that will hamper activity of sql server as a whole. If yes is there any othe method to do so. Please adviseThanks and RegardsPramod" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-09 : 07:26:50
|
| http://www.nigelrivett.net/SQLTsql/ImportTextFiles.htmlMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
bcp