Viewing 15 posts - 3,886 through 3,900 (of 14,953 total)
Roy Ernest (6/28/2011)
I forgot the fact that it was 2900 odd, I thought my post count was 1900 odd. 😛
And my posts are just plain odd.
June 28, 2011 at 8:13 am
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.
June 28, 2011 at 7:34 am
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...
June 28, 2011 at 6:24 am
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...
June 27, 2011 at 1:05 pm
Have you tried just running the select statement by itself?
June 27, 2011 at 11:21 am
Are you using anything beyond:
CREATE LOGIN [<domainName>\<loginName>] FROM WINDOWS;
Any options?
June 27, 2011 at 10:51 am
Avoid the extra outputs in the proc. What are they meant to do?
June 27, 2011 at 10:37 am
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.
June 27, 2011 at 10:35 am
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...
June 27, 2011 at 10:33 am
Are you creating them at the server level or the database level? (Logins or Users?)
June 27, 2011 at 10:31 am
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...
June 27, 2011 at 10:28 am
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.)
June 27, 2011 at 10:03 am
Here's a sample of what you seem to be describing:
CREATE TABLE #A
(ID INT PRIMARY KEY,
ColA CHAR(5)) ;
CREATE TABLE #B
...
June 27, 2011 at 10:01 am
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...
June 27, 2011 at 9:34 am
staindromeo1 (6/27/2011)
June 27, 2011 at 9:33 am
Viewing 15 posts - 3,886 through 3,900 (of 14,953 total)