How to retrieve data from XML file after Schema validation?

Question

In my XML file, it has this line with the top element. xmlns="http://tempuri.org/XMLSchema.xsd". I think this line it is used to conform with schema, Because I specified ValidationType in XmlValidatingReader instance to ValidationType.Schema. However, if I use xpath (XmlDocument's SelectSingleNode method ) to select node(s). It would not find any thing at all. Once I delete "xmlns="http://tempuri.org/XMLSchema.xsd"" from the XML file, it works fine? Could anyone please point out why I cannot retrieve data by Xpath after schema validation? Thank you very much

Answer 1

Frnds

 

not copied table data only procedure n function

Answer 2

madam

 

follow the below procedure to take script

 

 

 

Choose the advance button from the bellow dialog box at the top

 

 

select schema and data from the dropdownlist in the bellow dialogbox of option

 

Type of data to script

 

 

Answer 3

If the SQL server versions are same then just take a backup of your database (.bak file) and retore it in the new system. OR 

While generating the scripts choose "Schema With Data" option