Click here to Skip to main content
15,898,134 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL query Pin
greg lynch _nj_17-Apr-03 3:07
greg lynch _nj_17-Apr-03 3:07 
GeneralRe: SQL query Pin
si_6917-Apr-03 5:08
si_6917-Apr-03 5:08 
GeneralDummies guide to SQL Pin
Michael P Butler15-Apr-03 23:14
Michael P Butler15-Apr-03 23:14 
GeneralRe: Dummies guide to SQL Pin
perlmunger16-Apr-03 5:44
perlmunger16-Apr-03 5:44 
Generalfield=field+', ' in SQL Pin
stefan b15-Apr-03 23:08
stefan b15-Apr-03 23:08 
GeneralRe: field=field+', ' in SQL Pin
Jeremy Oldham16-Apr-03 2:29
Jeremy Oldham16-Apr-03 2:29 
GeneralRe: field=field+', ' in SQL Pin
stefan b16-Apr-03 18:47
stefan b16-Apr-03 18:47 
GeneralSQL 2000 Backup to SQL 7 Backup Pin
Paul Watson15-Apr-03 22:10
sitebuilderPaul Watson15-Apr-03 22:10 
Typical situation; Project spec calls for MS SQL 2000, come to install at client, client is running MS SQL 7.

There should not be much of a problem, they are not that different (not like 6.5 was to 7.)

However there is a problem; I backed up the SQL 2000 database. When I come to restore it on SQL 7 it gives an error (Error 3624, tableIndex < *****_ARRAYLEN.)


So I need to know: Can I convert a 2000 backup to 7? Is there a switch I need to set in SQL 2000 when I backup?

Any other bright ideas? Doing a script is no good because there is plenty of data in the database that needs to be retained.

Paul Watson
Bluegrass
Cape Town, South Africa

Macbeth muttered:
I am in blood / Stepped in so far, that should I wade no more, / Returning were as tedious as go o'er
Shog9:
Paul "The human happy pill" Watson
GeneralRe: SQL 2000 Backup to SQL 7 Backup Pin
Paul Watson15-Apr-03 22:57
sitebuilderPaul Watson15-Apr-03 22:57 
GeneralUpdating Multiple records through Storedprocedure and getting event notifications Pin
Mairaj Zeb15-Apr-03 20:42
Mairaj Zeb15-Apr-03 20:42 
Generaldata mining Pin
devvvy15-Apr-03 16:58
devvvy15-Apr-03 16:58 
GeneralSQL data to create directories Pin
gman4415-Apr-03 4:41
gman4415-Apr-03 4:41 
GeneralRe: SQL data to create directories Pin
Richard Deeming15-Apr-03 6:51
mveRichard Deeming15-Apr-03 6:51 
GeneralRe: SQL data to create directories Pin
si_6917-Apr-03 5:46
si_6917-Apr-03 5:46 
Generalreading a single record from SQL Pin
gollnick15-Apr-03 0:47
gollnick15-Apr-03 0:47 
GeneralRe: reading a single record from SQL Pin
perlmunger16-Apr-03 5:39
perlmunger16-Apr-03 5:39 
QuestionMS Access & BatchUpdate throw ADO ? Pin
rosen14-Apr-03 3:50
rosen14-Apr-03 3:50 
Generalsearch syntax problem Pin
ylaine14-Apr-03 1:09
ylaine14-Apr-03 1:09 
GeneralDataViewManager, Rowfilters and Child Filtering Pin
xpurt14-Apr-03 0:44
xpurt14-Apr-03 0:44 
GeneralDynamic SQL with in a stored procedure Pin
Venkatraman13-Apr-03 17:56
Venkatraman13-Apr-03 17:56 
GeneralPersonal Sql Server Pin
Steve McLenithan13-Apr-03 9:14
Steve McLenithan13-Apr-03 9:14 
GeneralRe: Personal Sql Server Pin
perlmunger16-Apr-03 6:01
perlmunger16-Apr-03 6:01 
GeneralRe: Personal Sql Server Pin
Steve McLenithan16-Apr-03 6:15
Steve McLenithan16-Apr-03 6:15 
Generalupdating 2 tables containing same value Pin
ylaine11-Apr-03 6:52
ylaine11-Apr-03 6:52 
GeneralRe: updating 2 tables containing same value Pin
Ixpah11-Apr-03 7:04
Ixpah11-Apr-03 7:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.