Search results

  1. Z

    Replication,

    I implement replication, a transactional replication, type Push. De database has some table with primary and forignkey.Now I get this message, 'Could not drop object because it is referenced by a Forignkey'. How can I fix this problem? Thanks
  2. Z

    Full_text index with 0 Item count?

    I have a table named Generics with 12 fields ID (numeric PrimaryKey) and ID_Name (Text) and .... The table has more dan 100000 records I make Full_text Index: 1. Right click on it and choose: 'Full_text Index Table'-> 'Define Full text...' 2. Select all defaults ( Memo is the field to...
  3. Z

    Replication,

    Thanks for you reply. Yes I am taking about MS SQL server 2000,I know about Merge model but I do not think that the merge model is a good solution. I will choose for a transaction replication because the data changed frequently. And the server2 is updated only from server1 not from two servers.
  4. Z

    Replication,

    Hallo, Is it possible one server at the same time to be Publisher and subscriber? I have three servers? server1, server2, server3. Server2 is publisher and server3 is subscriber for server2. Now the server2 must be update from server1 my question is can I set a new replication between server1...
  5. Z

    How can I start sql profiler without SA permission?

    I am database creator and I don?t have ?sa? permission but I want monitor my transaction. Is that possible, How? Thanks
Back
Top