Viewing 15 posts - 31 through 45 (of 70 total)
For the initial job, I would follow the excellent advice above. This would also get the dts packages -- the only other way I know without writing code is to...
January 28, 2004 at 7:21 am
The first thing I would do is establish basic communications. Can you ping the IP address of the FTP server from your SQL Server? It could be related to DNS...
January 28, 2004 at 7:03 am
Although I like MS products, Microsoft has never been one to quickly accept a court ruling except where it benefits them. MS has been struggling with the upgrade cycle...
December 12, 2003 at 6:44 am
Is there a specific reason for doing the join criteria in the where rather than in the join clause? Using the join is ANSI standard.
Joe Johnson
NETDIO,LLC.
December 1, 2003 at 8:04 am
Why are you breaking the date up that way? breaking up the date in the where clause that way will force a table scan.
You could probably increase...
November 24, 2003 at 7:42 am
Geez. I got it wrong. However, I feel justified because I was in the majority -- misery loves company and all that.
The date column threw me as I...
November 21, 2003 at 7:07 am
quote:
So.. now when we get a file from that system, we just open it up in Textpad and save as to...
November 18, 2003 at 7:07 am
ASP should be running under the IWAM account by default. How is security setup on the server that is running ASP? How is your SQL server login setup,...
November 17, 2003 at 8:15 am
These aren't specifically SQL Server, but I like gotdotnet.com, codeproject.com, and 4guysfromrolla.com -- some interesting articles and info.
I still haven't found a really good book that I like for .NET...
November 17, 2003 at 8:00 am
I had a problem with Unix text files similar to this, where the input was expecting a standard CR/LF at the end of each line -- in hex 13 and...
November 17, 2003 at 7:44 am
It is not very hard to do that if you know the commands to send to the web server. In one of my grad classes, we had to do...
November 5, 2003 at 10:13 am
I may be missing something, but if it is a small group program and you are obviously coding it, wouldn't the performance, security, etc be better if you implement the...
October 29, 2003 at 6:38 am
To build on your statements and to answer Philip...
In most instances, localization usually happens at the business logic stage, which is either in the client or the app server tier...
October 28, 2003 at 9:02 am
I found this split function on this site a while back -- it works great.
http://qa.sqlservercentral.com/scripts/contributions/157.asp
Joe Johnson
NETDIO,LLC.
October 27, 2003 at 8:21 am
This is about website server using Site Server and SQL and setting up a server farm. It might help depending on what you are doing. http://www.microsoft.com/siteserver/ssrk/rk_manage_whitepapers.htm
Joe...
October 24, 2003 at 7:02 am
Viewing 15 posts - 31 through 45 (of 70 total)