>The "Desktop" version must be installed on NT Workstation... But don't get
>your knickers in a twist, it has all the same stuff that the standard
>edition has.... Now no more excuses.... get to work!! :-)
>MCSE, MCT, SQL Server MVP
>IKON Education Services - C*te, NC
>(Please respond to newsgroup unles otherwise requested.)
thanx Wayne. Yes I found this already yesterday. At first didn't
want to install Desktop, thinking it a watered-down version of
some kind. But then figured, 'well if that's all I can install
on Workstation, I'll give it a try and see how it performs'.
So installed. One nice feature of the installation is that it
doesn't tell you you need to be logged in as adminstrator. If
you're not then, and you try installing, it hangs mysteriously,
again with no message, on one of the dialogs, Hit Previous,
Next, Cancel: no effect.
Now I have to move my db from the old server to the new. Tried
backup and restore. Hmmm don't seem to be able to see my
backup kit from the new database. Why's that? So then
I created the new db empty on the new server, dumped all
the SQL scripts out from the old and reran these in the context
of the new. Then set up a DTS on the new corresponding to that
in the old and imported the first table from our legacy
system (VMS) that drives all subsequent tables. That is,
most of the data in 10 tables is driven by a first, single
This worked but there must be a better way to transfer a db
in its entirety from one server to another?
In addition, I tried setting a DTS between the old and new
servers, and it gave some kind of message about 'you license
doesn't support this'. I'd been told that we'd bought a
fairly gold-plated license and so was surprised by this.
Is the ability to transfer whole dbs between separate
servers something you have to pay extra for? Hmph.