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 - 2000-12-07 : 08:34:17
|
Sam writes "I have a linked server that connects up to a Excel spreadsheet.
It all sits on the same server and every 3 mins a shecduled stored procedure kicks off and imports a bulk group of data into one of our tables.
The server is slowing down alot and I'm pretty sure this process is the main culprit.
I'm thinking of somehow getting the same info into a text file and importing that instead but I need to justify this with the client.
When the linked server is active does it require the excel engine to be up and running in the backgroud ? Is this permanantly open ? An other ideas about painless ways to update around 3000 records every 3mins ?
Any help would be much appreciated.
Cheers" |
|
|
|
|
|
Linked Servers