It didn't ask the key before because before you installed only sql tools, but when you try to install full sql server it promts for key.

Thank you so much, it works.

Access understands bigint in SQL as Text datatype. Why it can't hadle it as text datatype?

The second query is much faster and do the job.

Thank you very much.

I'll try all ways and let you know.

You absolutely right about normalizing this table, but it's not in my power.

What I supposed to do was:

select ID, col1,col2, ..., col12 where (col1=col2 or col1=col3 ...or col1=col12) and col1 is not NULL and col2 is not null...and col12 is not null...

Duplicates are for ID=1 - col1 and col12, for ID=2 - col1 and col3, and another pair col2 and col12, for ID=3 and 4 - no dups. I want to update...

You can create stored procedure with encription.

Look in cluster administrator, you will see it online.

Look in BOL

SELECT a.*

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

   'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'mypwd', Orders)

   AS a

GO

Try this

/****** Object:  Stored Procedure dbo.index_all_tables    Script Date: 5/19/00 12:24:02 PM ******/

CREATE PROCEDURE index_all_tables

AS

/*

 This procedure will generate a short report of the sp_helpindex

 output for all tables within this database.

*/

DECLARE...

Can somebody publish the script for sp_generate_script?

Thanks so much, it works.