Click here to Skip to main content
16,017,261 members
Home / Discussions / Database
   

Database

 
AnswerRe: Oracle, inner join and substr function Pin
Jörgen Andersson20-Mar-15 13:20
professionalJörgen Andersson20-Mar-15 13:20 
GeneralRe: Oracle, inner join and substr function Pin
Ludwing RS23-Mar-15 8:02
Ludwing RS23-Mar-15 8:02 
QuestionSSRS merging main header of two columns into one and then splitting subheadings Pin
indian14316-Mar-15 12:39
indian14316-Mar-15 12:39 
QuestionSSRS Report not allowing to edit name of the field Pin
indian14316-Mar-15 11:44
indian14316-Mar-15 11:44 
AnswerRe: SSRS Report not allowing to edit name of the field Pin
Richard Deeming17-Mar-15 3:42
mveRichard Deeming17-Mar-15 3:42 
GeneralRe: SSRS Report not allowing to edit name of the field Pin
indian14318-Mar-15 12:46
indian14318-Mar-15 12:46 
QuestionHelp with SSAS project Pin
rafael.avaria16-Mar-15 7:10
rafael.avaria16-Mar-15 7:10 
QuestionProblem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 6:38
delgaillo12-Mar-15 6:38 
Hello guys, this is my first message in codeproject.

My problem is the next, I have two databases in two different servers of SQL SERVER 2012, both, and I am using indexed views, functions that calling to that indexed views, Full-text catalogs ...

I need to have the same structure in both, I do change the database 1 and, I want to have the changes in the second without creating everything from the start. I have tried using scripts and tools like db comparer. I choose the elements or the execution of the script step by step, by order, for avoiding impact problem.

Well, I have the following error:

SQL
You can not use the CONTAINS or FREETEXT predicate on table or indexed view 'dbo.vwProducts', because it is not full-text indexed.


When I create the script, I select the option of creating "Full-text catalog", but definitely it doesn't create the Full-text catalog correctly. Is there any option of creating a script respecting the data from the database 2 and also incorporating "Full-text catalog" and other changes?
AnswerRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 14:51
professionalMycroft Holmes12-Mar-15 14:51 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 22:12
delgaillo12-Mar-15 22:12 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 22:14
professionalMycroft Holmes12-Mar-15 22:14 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo28-Sep-15 0:17
delgaillo28-Sep-15 0:17 
QuestionCreating SQL statements in Access Databases Pin
Member 115083508-Mar-15 14:25
Member 115083508-Mar-15 14:25 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 15:33
professionalRichard Andrew x648-Mar-15 15:33 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 15:42
Member 115083508-Mar-15 15:42 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 15:48
professionalRichard Andrew x648-Mar-15 15:48 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 15:59
Member 115083508-Mar-15 15:59 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 16:21
professionalRichard Andrew x648-Mar-15 16:21 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 16:25
Member 115083508-Mar-15 16:25 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 16:56
Member 115083508-Mar-15 16:56 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 17:18
Member 115083508-Mar-15 17:18 
GeneralRe: Creating SQL statements in Access Databases Pin
Chris Quinn8-Mar-15 22:07
Chris Quinn8-Mar-15 22:07 
AnswerRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 6:51
Abdulnazark9-Mar-15 6:51 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 17:01
Member 115083509-Mar-15 17:01 
GeneralRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 21:06
Abdulnazark9-Mar-15 21:06 

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.