Rosetta Genomics 10-Terabyte Human Genome Database:

http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp

True, I hadn't thought of that. My initial thought was that a lot of companies will save info for everyone that has worked there. Thus the flag would have been my...

Or you can just keep the salaries in TBL_SALARY_HISTORY. Make id_employee, id_speciality, date the primary key and maintain integrity by using a foreign key that references TBL_EMPLOYEE and another that references TBL_SPECIALITY....

Will using OPENQUERY work?

Something like:

SELECT * FROM OPENQUERY(MONORA,'SELECT * FROM JZOP.IZDVOJENA_OR')

DataFactory from Quest.

You should be able to get a trial version to get you by.

http://www.quest.com/datafactory/

While this is not a solution, it may shed some light into the issue and lead you down a path of solving it.

http://support.microsoft.com/default.aspx?scid=kb;en-us;330307&Product=sql2k

I'd like to know more. Is this a special product version you have to request or does the evaluation version of Lite Speed recognize that you are running Developer Edition?

How else would I create the primary key for the table? (other than when the table gets created) The only way to create the pk constraint would be to use...

I guess the question has more to do with the index than the pk in that when you create a pk for a table whether it is clustered or not...