HI..

Yes, it a local installation and SQL server is running.

But when I go to the Enterprise Manager and click

the server icon, it says connection failed and check

the SQL registration...

Hi, SQLBill:

I used Windows only authentication mode.

Yes, I did register the SQL server in Enterprise Manger. It registers successfully but as soon as I click the server icon it...

Thnaks Jay. I recreated the table. Is this how one would re-index the table when

data is deleted.

NG

Hi Jpips:

Thanks for the reply. I do have the identity setup in my table to increment it by 1. I removed whole bunch of data in the table then I...

Hi...

I just would like to thank to those who replied my question..

newid() works perfect !!

NG