Click here to Skip to main content
16,016,736 members
Home / Discussions / Database
   

Database

 
Questionhow can i transfer data Pin
Member 1141305829-Jan-15 12:55
Member 1141305829-Jan-15 12:55 
AnswerRe: how can i transfer data Pin
Mycroft Holmes29-Jan-15 13:41
professionalMycroft Holmes29-Jan-15 13:41 
GeneralRe: how can i transfer data Pin
Member 114130581-Feb-15 5:23
Member 114130581-Feb-15 5:23 
AnswerRe: how can i transfer data Pin
Umer Akram29-Jan-15 18:52
Umer Akram29-Jan-15 18:52 
GeneralRe: how can i transfer data Pin
Member 114130581-Feb-15 5:24
Member 114130581-Feb-15 5:24 
GeneralRe: how can i transfer data Pin
Umer Akram3-Feb-15 18:43
Umer Akram3-Feb-15 18:43 
QuestionModify the computed expression of computed column Pin
indian14327-Jan-15 6:41
indian14327-Jan-15 6:41 
AnswerRe: Modify the computed expression of computed column Pin
Richard Deeming27-Jan-15 7:02
mveRichard Deeming27-Jan-15 7:02 
As the first error says, you have an index on the table called IX_ApplicationData_ApplicationId-ReportingFpl_PriorityPoints-ContractorPriorityPoints which uses the computed column, so you can't drop the column without dropping the index first.

  1. Find any indexes which use the column;
  2. Generate both a drop and a create script for each affected index;
  3. Run the index drop scripts;
  4. Drop your column;
  5. Add the new version of the column;
  6. Then run the index create scripts.




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


AnswerRe: Modify the computed expression of computed column Pin
deepakdynamite28-Jan-15 0:27
deepakdynamite28-Jan-15 0:27 
QuestionBLOB or external storage... Pin
Kornfeld Eliyahu Peter26-Jan-15 20:57
professionalKornfeld Eliyahu Peter26-Jan-15 20:57 
AnswerRe: BLOB or external storage... Pin
den2k8826-Jan-15 21:32
professionalden2k8826-Jan-15 21:32 
AnswerRe: BLOB or external storage... Pin
GuyThiebaut26-Jan-15 21:48
professionalGuyThiebaut26-Jan-15 21:48 
AnswerRe: BLOB or external storage... Pin
Jörgen Andersson26-Jan-15 22:13
professionalJörgen Andersson26-Jan-15 22:13 
AnswerRe: BLOB or external storage... Pin
Richard Deeming27-Jan-15 1:50
mveRichard Deeming27-Jan-15 1:50 
GeneralRe: BLOB or external storage... Pin
Jörgen Andersson27-Jan-15 3:06
professionalJörgen Andersson27-Jan-15 3:06 
AnswerRe: BLOB or external storage... Pin
deepakdynamite28-Jan-15 0:30
deepakdynamite28-Jan-15 0:30 
QuestionDatediff function Pin
Ambertje26-Jan-15 2:18
Ambertje26-Jan-15 2:18 
AnswerRe: Datediff function Pin
Chris Quinn26-Jan-15 2:25
Chris Quinn26-Jan-15 2:25 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 2:34
Ambertje26-Jan-15 2:34 
GeneralRe: Datediff function Pin
Chris Quinn26-Jan-15 2:42
Chris Quinn26-Jan-15 2:42 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 3:12
Ambertje26-Jan-15 3:12 
GeneralRe: Datediff function Pin
Chris Quinn26-Jan-15 3:18
Chris Quinn26-Jan-15 3:18 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 3:26
Ambertje26-Jan-15 3:26 
GeneralRe: Datediff function Pin
Jörgen Andersson26-Jan-15 21:17
professionalJörgen Andersson26-Jan-15 21:17 
AnswerRe: Datediff function Pin
PIEBALDconsult26-Jan-15 5:57
mvePIEBALDconsult26-Jan-15 5:57 

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.