Search results for query: *

...is logged there. But those same triggers decided to put my login and the date I ran the query in its update fields, so clearly it 'thinks' I did *something*. I've never seen that behavior before, and I've been in these databases for years now. And of course it's the production DB, since I...

I wrote the following query to update a table in a mysql database from sql server. I cannot figure out why this wound up updating the updatedate field for some 3000 records on the linked SQL server. It should have been the source of updated fields. I can't tell what it might have updated, if...

...work, but turns out their setup allows a bit too much internally by default. Is there any simple way to add a new domain user and restrict it from *everything* by default, and then add the specific directory? Unfortunately, local account on webserver doesn't work. Looks like it has to be a...

In case anyone in the future comes along looking for the answer.... The class needed to look like this: Partial Public Class cXMLRequestShipNoticeRequestShipControlCarrierIdentifier Private domainfield As String Private valueField As String...

I need to create an XML file that looks like this: <ShipControl> <CarrierIdentifier domain="SCAC">FDE</CarrierIdentifier> </ShipControl> I have: Partial Public Class cXMLRequestShipNoticeRequestShipControl <System.Xml.Serialization.XmlElement()> _ Public CarrierIdentifier() As...

...this directory! I am able to simply copy the file if I create it locally, logged in as that domain account to windows. I just can't do it programatically, and I need the *service* to do it. What mysterious permission or setting needs changed so I can create this file in the proper location??

The old hard drive is connected as a slave - the OS on it won't boot, but we have everything on it except for whatever key piece of windows got trashed, preventing it from booting. The old certificates are there. Just no pfx. I told them I'm pretty sure they're hosed, too. But if there's any...

My customer had a certificate on their server 2003 machine. It was called when encrypting and decrypting credit card numbers. The machine inconveniently went kaput this week without warning. OS is apparently trash. We have everything running again, but have no way to access the old credit...

...= 'c:\dir\filename.xml' EXEC('INSERT INTO XmlImportTest(xmlFileName, xml_data) SELECT ''' + @xmlFileName + ''', xmlData FROM( SELECT * FROM OPENROWSET (BULK ''' + @xmlFileName + ''' , SINGLE_BLOB) AS XMLDATA ) AS FileImport (XMLDATA) ') GO create table #t (row int, NetworkID...

What are you trying to insert into the table? Are you sure you know how many characters it *actually* is?

Can you order by JobNum, ShipDate and select Top 1 ?

2005 sp3

I have XML Data that looks like this. <?xml version="1.0" encoding="UTF-8" ?> <CustomerMapping xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <CustMap NetworkId="AN01000018306-T" CustID="Testing" /> <CustMap NetworkId="AN01000018304-T" CustID="Nobody" /> </CustomerMapping> Over...

(I should be more specific. I did try that, and it didn't fix it. :-) )

Yes, I did try that, thanks.

I have a new service that watches a directory for new xml files and takes action when one is added/changed. When I add the following code, I find that once I save a file in the watched directory, I'm no longer able to access it. My service has it locked up. Offending code: Dim xpathDoc As...

I need to use a schema in Visual Studio, and VS requires it to be an XSD. I've not done XML in VS before (I'm really a SQL person that used to be a programmer and now I get to wear more hats). I've used both XMLSpy and xsd.exe to convert a DTD to an XSD. But when I do, it always creates THREE...

Nevermind, got one working with WebRequest.

God, I hate being a newb again! I have successfully avoided all this web-service stuff that started in with programming when I jumped from being a standalone VB6 app programmer to a SQL person. But it turns out that while I've been gone from the developing world, things, um, changed. I need...

XML Spy doesn't go for free anymore, sadly. $160 for the Standard ed and I think I might need the pro. Alchemist seems to just connect to mysql and oracle, but I need xml to be both source and destination. Seems like it should be so simple, and I must be overlooking something. I hate being...