how to resolve this issue ?. or what i have do to stop this error message ?

Thanks in advance .

can you tell me how to create rdl file ?

is there any spceific reason for not creating constraint while using the select * into ...

reason is there are somany tables so its taking lot of time to generate script and applying geneated script on the data base .

thanks...will check and let you know ...

-T 2551

-T 8003

s ...its different shema thanks for your reply

sp_lock session id will the table name with status as wait . instead of table name ,i want find out the statement or line no of stored procedures

Am using checksum(newid()) .....

Thanks For your Reply

I have tested with rand() but its generating duplicate number . I need unique number for each transaction in my application thats why .

Am getting the row id from sp_who when blocking happen . reason is same row id blocking somany session id .

can i able to see the data of key ?

i want retrieve the data from data base files not from table . each row has one unique row key ,if blacking happen its showing that row id for...

my childb table having less data compare with childa table .eventhough its taking childa table . i have clustered index on the childb table .