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 TouchToneTommy 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: *

  1. datamodeler

    Cluster Primary Key

    If I define a primary key constraint, the system will create an index for me. That is fine. How do I get it to be the cluster index for the table? Should I simply define a unique index but not indicate that it is the primary key? I do not like this because of the loss of metadata. Any...
  2. datamodeler

    TRIGGER STATUS

    I have multiple update triggers defined on table "XXX". Does each of them, when it fires, see the identically same "new" and "old" tables? Does "new" contain ALL columns of table "XXX" even though only some of them are updated? What about "old"? Mike Harris Data Modeling & Administration
  3. datamodeler

    wierd behavior in alter table

    Perhaps I am blind or just dumb but I cannot figure out why this statement alter table PROD."mchTEST" alter createdat set default current_timestamp; produces this output alter table PROD."mchTEST" alter createdat set default current_timestamp DB21034E The command was processed as an SQL...
  4. datamodeler

    Mail merge TO Word

    I want to be able to have an SQL Server 2000 trigger cause the execution of a mail merge within Word 2000. Unfortunately the informaion concering the sp_OA... stored procedures leaves something to be desired - in my opinion. Can anyone out there provide a small example? Mike Harris Data...

Part and Inventory Search

Back
Top