Sorry to bump this one but I couldn't resist.

SqlSpec is cheaper and better than any of these. plus it does several other RDBMS besides SQL Server.

yea, one way this can happen is if you are running the service under a certain domain acct, but are using the wrong password.

...as is/was Yukon

sql express is meant for just your type of customers. it's a freebie for small businesses and hobbyists to try to get them hooked on MS SQL, as opposed...

How are you connecting to mysql though? if you use ODBC, then you need to install a mysql ODBC driver:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

also there is MySQL Connector/NET which is...

if you are storing them as unicode, then it's no problem. Just use the -w flag to specify that you want to create a unicode file as output.

see http://msdn2.microsoft.com/en-us/library/ms162802.aspx...

try specifying -r"\r" instead of -r"\n". I am guessing that your lines are separated by carraige return/line feed instead of newlines.

see http://msdn2.microsoft.com/en-us/library/ms191485.aspx for details on the -r flag.

I responded to this here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76148

seems like a better solution would be to write the file to a file or web server that the sql server has write perms to, and then return the (web...

Sergiy, you are stubborn!

I was brought up on C++, where resource management is something that you need to be aware of, and you...

This is an amusing discussion. []

I think the position that explicitly dropping temp tables is a best practice is a reasonable one. why?...

I think this is what you are looking for:

http://msdn2.microsoft.com/en-us/library/ms190387.aspx

I think you'd be a lot better off if you adopted a different naming convention for your columns too. [supv #] is pretty bad. how about supervisorNumber or...

what is your question exactly? I don't see a question in this post anywhere.

hehe, ok.

I just assumed that the time is what you want to minimize because that's what most people care about.

if there's a shorter way on surface streets to get to...