SELECT  FK.[Name], TBL.[Name]

FROM sysobjects FK INNER JOIN sysobjects TBL

   ON FK.parent_obj = TBL.id

  WHERE FK.xtype ='F'

Did like above . is there any other straigh forward way of doing it

Thankx

I couldn't find it earlier

thankx again

IT WORKSSSSSSSS!!!!!!!

Thankx rockmoose  and Chiara for the great help

NOOOOOOO it is not working from VB

here is VB code

 connSConfig.Execute "SET IDENTITY_INSERT [AlarmClass] ON"      

connSConfig.Execute "Insert into [AlarmClass] (ID,AlarmClass,Priority,BPM,WAVFile,PlayType,VectoringGroupID,AlarmHelpStringID,AlarmMsg,AlarmTextColor,AlarmBackColor,AckTextColor,AckBackColor) Values (11,'Cleared',10,10,'','',0,1,'',16777215,16711680,0,16777215)"

this gives folowing error

Cannot insert explicit value for identity column...

Thankx I will check and let you know

Sorry I couldn't tell you. I want it to do from VB / ADO will I be able to use same command from that also.

I can't try it here...

UPDATE a SET VectoringGroupID = 1

from AlarmConfig A INNER JOIN AlarmDef B

ON A.AlarmDefID = B.AlarmDefID

Where B.PointId = 2

Get a book. I think it is the better way of learning.

And try to participate in this type of discussions. SQLServeCentral is another great resource which you will find

Good...

Thankx all for your comments which help me lot

Yes Bill , U are absolutly correct.

I think best option is DTS

CHeck this

Can u put some sample data here

Select Distinct (CNAME) From CustomerDetails

Select Len('Dianesh Asanka') -  CHARINDEX(reverse('an'),reverse ('Dianesh Asanka'),0) - 1

Not sure above is correct

But u can use CharIndex,reverse,Len functions to achive this