Viewing 12 posts - 1 through 12 (of 12 total)
I was given a mandate to return info about certain table field characteristics as well as the data in a certain XML format. In order to accomplish that, I needed...
March 17, 2004 at 1:46 am
To be more specific, it seems that the stored procedure is inserting a line break within the XML text string to invalidate it. I run the query thru QA...
December 17, 2003 at 4:59 am
Well, that will work. However, I am getting this error message below.
Cannot open output file - c:\xml\mscunits.xml
No such file or directory
The file and directory structure exists on the machine...
December 8, 2003 at 8:26 am
Greetings Mia,
Thanks for your help. I think it is producing the XML format I am seeking. I did not realize how important...
November 25, 2003 at 10:21 am
sims and column1 are one in the same. These columns along all of the other columns are coming from just table. The format I gave represents the hierarchy...
November 25, 2003 at 9:23 am
I am pulling all data from that table.
Patrick Quinn
TRMS Database Administrator
-------------------------
Patrick Quinn
TRMS Database Administrator
Anteon Corporation
09641-83-7722, DSN 475-7722
November 25, 2003 at 9:11 am
I am pulling all data from that table.
Patrick Quinn
TRMS Database Administrator
-------------------------
Patrick Quinn
TRMS Database Administrator
Anteon Corporation
09641-83-7722, DSN 475-7722
November 25, 2003 at 8:59 am
Well, in fact, the corps, msc, submsc, subsubmsc fields are only from one table with one primary key - PK1. How does this affect the XML query?
Patrick Quinn
TRMS Database...
November 25, 2003 at 8:10 am
I already ran a similar query and I got no results back. So, there does not appear to be any duplicates.
Patrick Quinn
TRMS Database Administrator
November 18, 2003 at 2:24 am
What about if you have an existiny rowentry of lets 1010 characters, and I would like to paste in 30 additional characters. Will EM allow this to happen?
Patrick Quinn
TRMS...
August 7, 2003 at 6:35 am
I got it all working. It was a permissions issue through SQL Agent. Thanks for your all your help.
May 30, 2003 at 2:10 am
I created the whole script with Profiler. I am using the user account with full system admin privileges. Does the SQL Server engine need some kind of access...
May 29, 2003 at 3:29 am
Viewing 12 posts - 1 through 12 (of 12 total)