locked
Datasource Configuration Wizard Problems RRS feed

  • Question

  • Hi all,

    I have to build an offline windows application which should sync to the Live database on the server whenever its connected to network.
    I came across this nice link http://technet.microsoft.com/en-us/sqlserver/Video/dd407782.

    I followed the steps and got stuck-up where it asked me to "Choose Your Database Objects". I selected the desired tables and click Next.

    On the next screen "Choose tables to cache", I am unable to select the tables which are showing in a list. The check-box is disabled and don't let me select anything.

    Please help.

    Thanks,

    Deepak

    Friday, July 27, 2012 11:12 AM

Answers

  • the wizard wont allow you to pick tables without a PK.
    • Marked as answer by Catchbobbie Friday, July 27, 2012 2:41 PM
    Friday, July 27, 2012 1:45 PM

All replies

  • does your table have Primary keys?
    Friday, July 27, 2012 1:23 PM
  • Nopes..

    Thanks & Regards, Deepak

    Friday, July 27, 2012 1:30 PM
  • the wizard wont allow you to pick tables without a PK.
    • Marked as answer by Catchbobbie Friday, July 27, 2012 2:41 PM
    Friday, July 27, 2012 1:45 PM
  • Got it... There was no Primary key defined in my table on server.

    There was a column but I removed the PK just to import data.

    Thanks for your help and time ...

    :)


    Thanks & Regards, Deepak

    Friday, July 27, 2012 2:17 PM