Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Freehansje
  • Content: Threads
  • Order by date
  1. Freehansje

    Strange primary key behaviour

    Consider the following: There is a table with 2 attributes, COPInstantieID as Int and LoketID as Int. Those 2 attributes are also the primary key. At some point an ExecuteSQL task runs this script: INSERT INTO Centraal.InstantieLoket( COPInstantieID, LoketID ) SELECT t1.COPInstantieID, 1 FROM...
  2. Freehansje

    SQL Script problem

    I have this table CREATE TABLE table1( Proc VARCHAR(10), PrevProc VARCHAR(10)) Both fields are mandatory. In this table sequences are stored of jobs to run. PrevProc will hold the name of the job which has to finish before the job in Proc can run. What I need is a resultset per sequence, which...
  3. Freehansje

    Sudden replicationproblem, unsolvable?

    Hi, We're running a replicationprocess for months now, and 2 days ago it broke down, for no appearant reason I can detect. The setup is this: A SQL2K server has a publication defined on a database, consisting of several dozen tables. It is a transactional publication, running continuously. There...
  4. Freehansje

    Chances from CDM to PDM, and viceversa, how?

    Hi there, I am new to PowerDesigner and I am playing with it to find out, if my department can benefit from it. What I really want to know, and cannot find on the Sybasesite is this: If I have a MODEL.CDM and a therefrom generated MODEL.PDM, can I automatically apply changes made in the CDM to...

Part and Inventory Search

Back
Top