I'm getting the following error with SQL 7 regarding DTS inability to transform data.

A. In the very small-print on the license agreement it says you can't do distributed operations (dist. query, replication, DTS) between SQL Server Desktop and Standard/Enterprise version if the Standard/Enterprise version is installed in "per server" mode.

Switch the SQL Server to "per-seat" mode" via the licensing applet in control panel.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.