Professional Web Applications Themes

Does SQL Server 2000 Import Data feature ever work? - Microsoft SQL / MS SQL Server

Hi, I was trying to copy some tables, stored procedures and relationships from an MSDE database to SQL Server 2000 database. As usual the Import failed. I've never seen this thing work... ever. Is there a trick to it or is it there to look pretty but do nothing? Sam...

  1. #1

    Default Does SQL Server 2000 Import Data feature ever work?

    Hi,

    I was trying to copy some tables, stored procedures and relationships from
    an MSDE database to SQL Server 2000 database. As usual the Import failed.
    I've never seen this thing work... ever.

    Is there a trick to it or is it there to look pretty but do nothing?

    Sam


    Sam Guest

  2. #2

    Default Re: Does SQL Server 2000 Import Data feature ever work?

    Sam;
    I am sure I got it to work once.
    Can't remember how though & never being able to repeat my success I
    eventually put it down to a figment of my fevered imagination.


    J.


    "Sam" <com> wrote in message
    news:phx.gbl...
    Hi,

    I was trying to copy some tables, stored procedures and relationships from
    an MSDE database to SQL Server 2000 database. As usual the Import failed.
    I've never seen this thing work... ever.

    Is there a trick to it or is it there to look pretty but do nothing?

    Sam


    Jonathan Guest

  3. #3

    Default Re: Does SQL Server 2000 Import Data feature ever work?

    I've used it many times, even between servers. There are lots of ways to
    break it though, especially where object level permissions are involved.
    What are your specific problems?

    Bob Castleman
    SuccessWare Sofware

    "Sam" <com> wrote in message
    news:phx.gbl... 


    Bob Guest

Similar Threads

  1. Replies: 2
    Last Post: March 7th, 12:43 PM
  2. Inserting data from Oracle to SQL Server 2000
    By Tim in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: August 8th, 11:16 PM
  3. Import data from Fox Pro database into SQL 2000
    By Dave Navarro in forum ASP Database
    Replies: 1
    Last Post: July 31st, 03:31 PM
  4. data encryption in sql server 2000
    By Dinesh.T.K in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 9th, 11:08 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139