Thank You all for your quick help.

There was a existing schema owned by him in the database. So, When I dropped the schema I was able to map him to that database.

Yes i am mapping it to correct database.

Yes I refreshed but not working

Under db security - > under schemas , I see a schema with the same UserName. can I drop it ?

Can anyone please help me in having the version tag line on the top of the xml file generated by script I provide.

Thanks in advance

I used this sql script and generated the xml file through ssis script task and execute sql task. But I am not getting the version code on the top of...

Thank You so much......I am working on it to submit to my manager.

Thanks once again

SELECT (SELECT top 2 ProductID,EComProductID FROM Products FOR XML AUTO, TYPE).query(

'<Record>{

for $c in /Products

return

<Prop name="PrdouctID">

<Pval >{data($c/@ProductID)}</Pval>

...

I need to write a sql query using for xml and get the data in this format

<Pval> need to hard coded.

Its SQL2008

I created the sp first and then I gave exec permissions to other person. so the other person got the error which I pasted. we tried and tried but...

All the permissions are good.Thanks for the reply.

I found the soultion. Its really crazy, I do not know why and how but it worked.

I droped the procedure and recreated and...

Thanks, Its working now.