Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2015-01-19 : 06:03:22
|
| Hello,My query inserts data from views into a table...Recently this has been giving the error "Root Element is missing"my search on the web indicates that this error is to do with xml. But, there is no xml related query in the insert or in the views...Any suggestions please?Thanks |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-19 : 06:32:01
|
| post the DDL of the tables involved |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2015-01-19 : 06:56:37
|
quote:
Originally posted by gbritton
post the DDL of the tables involved
All I run in visual studio is a stored proc. which calls views to insert into a table i.e. insert into table 1 select * from view1 insert into table 1 select * from view2 insert into table 1 select * from view3 insert into table 1 select * from view4 insert into table 1 select * from view5 ...Each view calls other tables. As simple as that. Sometimes the error "Root element is Missing" is given in visual studio.Thanks |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-19 : 07:39:41
|
| That's DML, I need to see the DDL (CREATE TABLE) statements |
|
|
|
viggneshwar
Yak Posting Veteran
86 Posts |
Posted - 2015-01-21 : 08:55:51
|
| This error will come only on the XML element is missing. If you are not using XML in your code then please provide the detailed simulationsRegardsViggneshwar A |
|
|
|
|
|
|
xml