Hi all,

I have a stored proc that is begin called, and it is returning data that is not properly formatted (no root tags)

my stored proc is a simple one...


================================================== =====================
CREATE PROCEDURE [SP_XML_Get_Active_Users_By_VenueID]
(@venueID int)
AS
SELECT *
FROM Users INNER JOIN
User_Venue_XRef ON Users.UserID = User_Venue_XRef.UserID INNER JOIN
Venues ON User_Venue_XRef.VenueID = Venues.VenueID
WHERE (User_Venue_XRef.VenueID = @venueid) AND (Users.Deleted = 0)

FOR XML AUTO
GO
================================================== =====================



I am trying to call it from a web browser via this line....

http://laptop/heh?sql=execute+sp_xml_get_active_users_by_venueid +657

When the results are passed back there is not root tags....

now when i call it with this URL...

http://laptop/heh?sql=execute+sp_xml_get_active_users_by_venueid +657&root=root


It returns a fully qualified XML doc... with the root tags....


Does anyone have an idea why the stored proc is not returnning a fully qualified XML document????


thanks
tony