Click here to Skip to main content
15,921,905 members
Home / Discussions / Database
   

Database

 
AnswerRe: for searching specific records from sql server 2005 database Pin
Ashfield20-Nov-08 23:36
Ashfield20-Nov-08 23:36 
AnswerRe: for searching specific records from sql server 2005 database Pin
Jerry Hammond21-Nov-08 14:15
Jerry Hammond21-Nov-08 14:15 
Generalfiltering dataset and pu the result in another datatable. Pin
Aslesh20-Nov-08 12:03
Aslesh20-Nov-08 12:03 
GeneralRe: filtering dataset and pu the result in another datatable. Pin
Ashfield20-Nov-08 20:01
Ashfield20-Nov-08 20:01 
GeneralCross-post Pin
Wendelius21-Nov-08 22:42
mentorWendelius21-Nov-08 22:42 
Questioncopying a record from one database to another database in sql server 2000 using c# Pin
Berlus20-Nov-08 11:39
Berlus20-Nov-08 11:39 
Questionconvert MS SQL DB 2008 to 2005 Pin
Aslesh20-Nov-08 9:36
Aslesh20-Nov-08 9:36 
AnswerRe: convert MS SQL DB 2008 to 2005 Pin
Wendelius20-Nov-08 9:49
mentorWendelius20-Nov-08 9:49 
Restoring a backup to SQL Server 2005 which is taken from SQL Server 2008 isn't possible. The format is simply different.

One way to overcome this is to build an extra SQL Server 2008 instance, restore the backup there and then for using for example Export/Import you transfer the schema and the data from 2008 to 2005. There are several tools and options which you can use for the transfer (SSIS, scripting the database, bcp etc)

The need to optimize rises from a bad design.

My articles[^]

AnswerRe: convert MS SQL DB 2008 to 2005 Pin
Edin Jen Raj15-Jun-10 2:05
Edin Jen Raj15-Jun-10 2:05 
AnswerRe: convert MS SQL DB 2008 to 2005 Pin
Edin Jen Raj15-Jun-10 2:06
Edin Jen Raj15-Jun-10 2:06 
QuestionCOUNT PROBLEM Pin
member2720-Nov-08 1:40
member2720-Nov-08 1:40 
AnswerRe: COUNT PROBLEM Pin
RGTuffin20-Nov-08 2:54
RGTuffin20-Nov-08 2:54 
GeneralRe: COUNT PROBLEM Pin
member2720-Nov-08 17:15
member2720-Nov-08 17:15 
QuestionMatches from 2 tables Pin
highjo20-Nov-08 0:54
highjo20-Nov-08 0:54 
AnswerRe: Matches from 2 tables Pin
RGTuffin20-Nov-08 3:36
RGTuffin20-Nov-08 3:36 
GeneralRe: Matches from 2 tables Pin
highjo20-Nov-08 4:13
highjo20-Nov-08 4:13 
AnswerRe: Matches from 2 tables Pin
Wendelius20-Nov-08 7:32
mentorWendelius20-Nov-08 7:32 
Questionselect max(string) Pin
Zeyad Jalil19-Nov-08 19:49
professionalZeyad Jalil19-Nov-08 19:49 
AnswerRe: select max(string) Pin
Xandip19-Nov-08 19:54
Xandip19-Nov-08 19:54 
GeneralRe: select max(string) Pin
Zeyad Jalil19-Nov-08 22:17
professionalZeyad Jalil19-Nov-08 22:17 
GeneralRe: select max(string) Pin
Ashfield19-Nov-08 22:27
Ashfield19-Nov-08 22:27 
AnswerRe: select max(string) Pin
Syed Mehroz Alam19-Nov-08 19:58
Syed Mehroz Alam19-Nov-08 19:58 
GeneralRe: select max(string) Pin
Zeyad Jalil19-Nov-08 22:17
professionalZeyad Jalil19-Nov-08 22:17 
AnswerRe: select max(string) Pin
Paddy Boyd20-Nov-08 0:00
Paddy Boyd20-Nov-08 0:00 
AnswerRe: select max(string) Pin
RGTuffin20-Nov-08 0:46
RGTuffin20-Nov-08 0:46 

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.