Gail, That has helped even more. I will be looking for the next article next week. Thanks.

Thanks, Lynn. That really helped.

Indexes are existing on all the tables.

Hi Florian,

Thanks for your reply. What do i need to check/uncheck in Execution plan to set Full Table Scan OFF?

Thanks again.

Thanks to Matt Miller and Matt Whitfield. It has helped me tremendously.

Hi BitBucket,

That did help. I would have to change it a little, but thank you much for your time. I appreciate it.

Matt,

Let me clarify. I have a website "http://someSite.com/someXML.xml". This site contains an XML file. I want to open that xml file and dump the data into...

Matt,

I do not want to use anything other than sql to open an xml from a website. Is this possible?

Thanks.

Hi Matt,

Finally I got a response. Thank you. I want to open an xml file form a website directly from sql server 2005. Is this posible?...

Thanks again for your response. I am not asking for a script, but I want to run a script in sql. The script can be created in java to open...

Thank you for your time and response. I understand that xp_commandshell can either open the file for the website or run a script that has a code to open the...

Lutz and SteveB are correct. In this case I cannot create a trigger, but I need to schedule a job.

Thanks all for your time.

Thanks for the reply, but I am not clear.

Hi Garadin,

That worked. Thank you for your time. You saved my life.

I had to restore the DB and it is ok now. Should have done CheckDB, but now it is too late.

Thanks for your time.