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..