Thanks Folks!!

2nd question is now addressed

an you also let me know what special we need to do to get the below executed correctly

SET IDENTITY_INSERT USERS.ID ON

Where USERS(ID INT PRIMARY KEY, Name nvarchar(20))

I tried but it throws error saying, 'Either the object 'USERS' does not exist or you do not have permissions'

Please Help..