And my posts are just plain odd.

They can either use any normal XML-reader (SSMS works for that), or they can store the data as something other than XML. Those are really the options available.

No. Since those are part of the results of the proc, they are assumed to be something you want. If you don't want them, you need to tell...

It can work with any type of column.

The "with" statement defines a "recursive common table expression" (also called "recursive CTE"), and is used to crawl a hierarchy. If that's...

Have you tried just running the select statement by itself?

Are you using anything beyond:

CREATE LOGIN [<domainName>\<loginName>] FROM WINDOWS;

Any options?

Avoid the extra outputs in the proc. What are they meant to do?

I'm using GnuPG for encrypting files from SSIS 2005 before uploading them to an FTP site. I use a scripting object to call the command-line options I need.

Works great.

I guess it depends on what you want to do with a date that's a zero-length string. What does that represent, in terms of use/business logic?

If it means "we...

Are you creating them at the server level or the database level? (Logins or Users?)

If what you're looking for is a Select statement that will pull data from all of the tables in that schema, you'll either need to build that statement yourself, or...

Okay, you got me curious. Why delay creating the file by a minute?

(I'd probably just have used a T-SQL WAITFOR command, instead of a loop.)

Here's a sample of what you seem to be describing:

CREATE TABLE #A

(ID INT PRIMARY KEY,

ColA CHAR(5)) ;

CREATE TABLE #B

...

I'd have to see your code to really get what you're running into.

I've never had a problem with error messages, et al, ending up in the message anywhere, but maybe...

staindromeo1 (6/27/2011)

---

I tried your statement, I am getting a conversion error. There are 3 datatypes. 'Yes' 'No' And 'Other'. So right now the column has the value 'Other' & it...