you can just install the client tools from the SQL CD.

although the protected item behaviour sounds similar to a problem i've seen on web servers before - user get the...

is it the database backup, or the t-log backup?

is the database in simple or full restore mode.

also

have a look as DBCC opentran to see if there are any...

use dateadd, if it's the 61st day of the year add 60 days to jan 1st

DATEADD (d ,(61-1),'01/01/2004' )

jsut remember to make sure you select the correct primary key when you link the tables (or views).

and if you do change the tables then you need to refresh...

have you run a DBCC CheckDb on the database recently ?

no problem,

but just out of interest, why are you migrating from oracle??

not that i'm biased or anything, but most oracle DBA's see SQL as a toy database (i know my...

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...