Just use sp_detach_db and sp_attach_db
> Im having a DTS problem,
> I want to export (transfer) data from my desktop SQL 7.0 to a NT Server
> (standard Sql 7.0), but there is a message with something like " The license
> for the installation of MSQL on your source and destination connections does
> not permit the use DTS to transform data..."
> I was using SQL evaluation before, but i uninstalled it and reinstalled an
> original copy,.....
> any idea???
> maybe there is a way to do the upgrade... or i have to do something else...
Q. I'm getting the following error with SQL 7 DTS - "The license for the
installation of MS SQL Server on your source and destinations connections does
not permit the use of DTS to transform data. Refer to your license for more
A. In the very small-print on the license agreement it says you can't do
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
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
For SQL FAQ entries see
or www.ntfaq.com/sql.html (+ ntfaq download)