December 11, 2009 at 10:42 am
Paul Neilsen originally created the 1.04 package, but it only supported a table with one primary key. I revised the scripts to handle up to 3 primary keys defined per table. Read the attached doc and test it on a table.
Rudy E. Hinojosa
Database Administrator
United Drugs, Inc.
December 11, 2009 at 10:49 am
rudyhinojosa2007 (12/11/2009)
Paul Neilsen originally created the 1.04 package, but it only supported a table with one primary key. I revised the scripts to handle up to 3 primary keys defined per table. Read the attached doc and test it on a table.Rudy E. Hinojosa
Database Administrator
United Drugs, Inc.
Three PRIMARY keys? I am pretty sure that you can only have ONE primary key, although you may have several candidate keys that could be considered as primary keys. Those are usually called alternate keys by some people.
December 11, 2009 at 10:55 am
Forgive me Yoda, I meant composite primary keys.
December 11, 2009 at 12:02 pm
That makes much more sense
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply