yes,

in access just select the tables section and then choose import/link tables - you can then create a link to all of your SQL server tables

anything you do in...

run this query in Query Analyser with the output set to File

declare @tbname nvarchar(1000)

declare @strsql nvarchar(1000)

declare curs1 cursor for select name from sysobjects where xtype='u'

open curs1

fetch next from curs1 into...

yes, it could be the data driver you were using. it may have been "misinterpreting" the data.

stick with what works.

if you are interested microsoft have a dedicated page for migrations...

you can configure the port settings for MSDE/SQL by using the server network utility - that way you can choose the TCP/IP port to listen on.

the only things i can...

on a fast network TCP/IP and named pipes are comparable, but over a slower network or WAN then Pipes are much slower as the are more interactive than TCP/IP

TCP/IP doesn't...

just restore your user databases.

you can then script up your user log-ins and grant them permissions

all you have to do is clean up your orphans first.

what kind of data are you storing in your LONG? i take it it's just text data ?

have you tried using TCP/IP instead? - also make sure you connect by IP address and not by Server name, that way you avoid IP resolution issues.

what are you using for your migration ?

are you dragging the data from oracle using the SQL import, or are you pushing it from oracle somehow?

if you have created the...

have a look at a product called LOG P.I.

this can disect logs - but a better method is to create some triggers on your tables that audit deletes into a...

no problem at all.

you although only restore your user databases - the master database controls all sorts of info about your server and a SQL2000 and SQL7 master databases...

this data is stored in pages of data in the SQL data file.

max size for data is 2GB and can be accessed as if it were a normal varchar/nvarchar field....

why not just script out the objects by right clicking on the database and clicking on generate scripts.

you can then select all objects (including users) and your database is scripted...

in @subject ???

i'm not sure about anyone else, but i've never seen an email client that has formatting in the subject header - only in the body text.

if you are thinking about this then you should realy look at Citrix Metaframes as well. you can run your application as a seamless published app. (or on a citrix...