Click here to Skip to main content
15,177,264 members
Home / Discussions / Database
   

Database

 
QuestionSSAS Cube Pin
Mycroft Holmes6-May-14 15:42
professionalMycroft Holmes6-May-14 15:42 
QuestionNeed help in forming a query Pin
Member 99559846-May-14 1:07
professionalMember 99559846-May-14 1:07 
AnswerRe: Need help in forming a query Pin
Richard MacCutchan6-May-14 1:21
mveRichard MacCutchan6-May-14 1:21 
Questionlogin and logout differenece at back end Pin
Syed Rehman5-May-14 19:59
MemberSyed Rehman5-May-14 19:59 
AnswerRe: login and logout differenece at back end Pin
Mycroft Holmes5-May-14 20:20
professionalMycroft Holmes5-May-14 20:20 
QuestionMigration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 8:48
MemberKala Vairakkannu5-May-14 8:48 
AnswerRe: Migration error from SQL 2014 to SQL 2012 Pin
ZurdoDev5-May-14 10:36
professionalZurdoDev5-May-14 10:36 
QuestionMigration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 8:27
MemberKala Vairakkannu5-May-14 8:27 
I have a database(Eg. SALES) in SQL Server 2014 which needs to be recreated in SQL Server 2012 version. Since I can not use the SQL 2014 back up file in SQL 2012 environment, I have proceed with the Generate Script option and trying to run the script in SQL Server 2012 environment. However it is giving an error as Msg 102, Level 15, State 6, Line 1
Incorrect syntax near 'DELAYED_DURABILITY'.
which is pointing to the ALTER DATABASE [SALES] SET DELAYED_DURABILITY = DISABLED line in the script and not able to proceed further. Please help me to get this sorted out.
Thanks,
Kala


modified 5-May-14 14:45pm.

AnswerRe: Migration error from SQL 2014 to SQL 2012 Pin
Kornfeld Eliyahu Peter5-May-14 8:34
professionalKornfeld Eliyahu Peter5-May-14 8:34 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
ZurdoDev5-May-14 8:48
professionalZurdoDev5-May-14 8:48 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 9:16
MemberKala Vairakkannu5-May-14 9:16 
AnswerRe: Migration error from SQL 2014 to SQL 2012 Pin
LloydA1115-May-14 8:34
MemberLloydA1115-May-14 8:34 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
ZurdoDev5-May-14 8:47
professionalZurdoDev5-May-14 8:47 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 9:20
MemberKala Vairakkannu5-May-14 9:20 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
Kornfeld Eliyahu Peter5-May-14 9:24
professionalKornfeld Eliyahu Peter5-May-14 9:24 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 9:37
MemberKala Vairakkannu5-May-14 9:37 
QuestionMySQL: best for true or false, Yes or No, negative or positive Pin
Jassim Rahma3-May-14 5:44
MemberJassim Rahma3-May-14 5:44 
AnswerRe: MySQL: best for true or false, Yes or No, negative or positive Pin
Jörgen Andersson3-May-14 7:54
professionalJörgen Andersson3-May-14 7:54 
AnswerRe: MySQL: best for true or false, Yes or No, negative or positive Pin
Eddy Vluggen3-May-14 8:49
professionalEddy Vluggen3-May-14 8:49 
QuestionNot in for two columns with Inner join Pin
indian1432-May-14 10:18
Memberindian1432-May-14 10:18 
AnswerRe: Not in for two columns with Inner join Pin
Mycroft Holmes2-May-14 14:04
professionalMycroft Holmes2-May-14 14:04 
Questionhow to join all three query results to one in mysql Pin
sr1591-May-14 0:01
Membersr1591-May-14 0:01 
AnswerRe: how to join all three query results to one in mysql Pin
Simon_Whale1-May-14 0:12
professionalSimon_Whale1-May-14 0:12 
GeneralRe: how to join all three query results to one in mysql Pin
sr1591-May-14 6:34
Membersr1591-May-14 6:34 
Questionhow to fetch a table column of same name of more than 4 different database in sql server 2008r2??? Pin
Member 1078495429-Apr-14 21:24
MemberMember 1078495429-Apr-14 21:24 

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.