Viewing 15 posts - 1,846 through 1,860 (of 1,995 total)
have you run a DBCC CheckDb on the database recently ?
August 3, 2004 at 8:21 am
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...
August 3, 2004 at 8:10 am
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...
August 3, 2004 at 8:06 am
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...
August 3, 2004 at 7:45 am
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...
August 3, 2004 at 6:39 am
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...
August 3, 2004 at 3:58 am
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...
August 3, 2004 at 2:15 am
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.
August 3, 2004 at 2:09 am
what kind of data are you storing in your LONG? i take it it's just text data ?
August 3, 2004 at 2:06 am
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.
August 2, 2004 at 10:34 am
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...
August 2, 2004 at 10:33 am
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...
August 2, 2004 at 10:27 am
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...
August 2, 2004 at 10:24 am
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....
August 2, 2004 at 10:20 am
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...
August 2, 2004 at 10:15 am
Viewing 15 posts - 1,846 through 1,860 (of 1,995 total)