Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Amsterdam
    Posts
    18

    Unanswered: Adding a linked server?

    I have a huge table called "Clientdata" in a database called "Accounts" against which I have to run current month queries. Not only does this kill the box it runs on, but slows down everything in sight.

    What I would like to do is export only the current month records from this database\table to another database\table (Statements\Clientdata) by means of a stored proc.

    How do I setup the store proc as I have not done one yet ?

    Thanks

  2. #2
    Join Date
    Sep 2003
    Posts
    212
    y dont u use a DTS package?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •