Hi guys

    I have checked the coding.But it doesn't read the xml file properly.I am getting a message from #tempXML file that "The system cannot find the file specified." What...

You have to configure DTS for this.How to configure DTS for this?

Niladri

I don't want any site name.I don't want  to any utility.How is it possible through script? Can anyone give solution.Please don't mention any site name.

write code if possible.

Thanks

Regards

Niladri Saha

yes, it is possible. in stored procedure u write the following code.

       Select * from A.dbo.Employees if u want data from  A database

       Select * from B.dbo.Employees if...