am using a function

return

(convert(char(10),cast(@IntVal - 36161

date is stored in integer like  73459 when i do a convert I get this date 02/13/2002

I want this to be done for total column and show the result...

or is it something like there is no free space available to shrink any more.

Hey good guy..I accept it but i am not just dealing with password unique though they have same password they may have different userid, what i need is there can...

yeah but still i want an unique constraint or what ever for both userid and passowrd together.

Can i have constraint on existing table though it has duplicates existed, i want to...

I am not sure about unique contraints..does it work in that way. Actually I thought I can have a unique constraint with userid and pswd together. here userid can repeat...

If I have columns userid & password, can I have unique contraint on both of them so that both userid and password should be unique giving a chance for either...

do i need to check through each column? I wud like to check complete table if it has any coulumns that has unique data in it.

above query has syntax error.

Greg

by running your query i am able to get all the tables,references but how can I find circular references in it and get rid of them

do i need to do that for each table..is there a way i can do for total database.

Actually I have to check comeplte database for circular references and come up...

I ran the above script but in my result looks like

1301579675 mapilink                       0 0.000000 0.000000000 0.000000000 0.000000

1317579732 matter                         0 0.000000 0.000000000 0.000000000 0.000000

1349579846 matter2                        0 0.000000 0.000000000 0.000000000 0.000000

1381579960 matter3                        0 0.000000 0.000000000 0.000000000 0.000000

1413580074 message                        0 0.000000 0.000000000 0.000000000 0.000000

1445580188 notes                          0 0.000000 0.000000000 0.000000000 0.000000

1477580302 otldtl                         0 0.000000 0.000000000 0.000000000 0.000000

1493580359 otlhdr                         0 0.000000 0.000000000 0.000000000 0.000000

1525580473 pcmatter                       0 0.000000 0.000000000 0.000000000 0.000000

1557580587 phase                          0 0.000000 0.000000000 0.000000000 0.000000

1589580701 phone                          0 0.000000 0.000000000 0.000000000 0.000000

1621580815 popuid                         0 0.000000 0.000000000 0.000000000 0.000000

ok.

I truncated all the data in my DB using

-- disable referential integrity

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

GO

EXEC sp_MSForEachTable 'TRUNCATE TABLE ?'...

I get the following mesg for most of the tables when I run the query listed inthe link provided

Warning: The table empcontact' has been created but its maximum row...

I think, if i can get all table names with a script then I can do a "delete from 'tablename', how can i get just table names from a DB