i used an xml string sometime back and it did the trick for me

in that case i am forced to cede that F1 is the winner

not knowing much about the nascar except the odd snippet in the online papers i would say cricket, there is just an awful amount of items to be tracked. and...

i agree with micheal on his assessment. I think humans being humans, they are always the weekest link and this idea of encryption of data is one for the software...

goto to this post, hope it will help you

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=21&messageid=194568

create your stored proc the normal way and then just return the data as xml.

create proc cp_stationData

@staionid int

as

select esrw.stationID,esrw.trackID

from esrw

where esrw.stationID = @staionid

for XML AUTO

on the client side remember your...

i was thinking along the same lines but then he had said the app is a legacy app. I wonder, could you tell us what language is used for the...

you could probably run the osql with the runas command and then use the required windows id

do a search in the forums, this xml issue has been covered extensively before.

check in Control Panel > Administrative Tools > Services

if the agent service is set to automatic under the properties, may be that is the problem.

check if your machine does not have sql server express, most likey you installed when you installed the vs 2005 beta. goto to your control panel > add/remove programs.

if it...

yap noggin, you said it right. we cannot suggest a useful solution unless you answer noggin's question.

sorry if i caused you any offense, but i was thinking that your other line i.e.

meant it was not as good...

what problems is the sum causing, because the method you have chosen is not a very bright idea as you have said.

your request is not clear:

from what i can gather from your request

1. You have an xml file with records that you want to import into sql table(s).

i don't think you...