Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
Yes, if you refuse to read the documentation when pointed to it, there is a
lot that will be hidden to you.

True, the topic for SQLCMD is long, and I did not tell you when on the
page it is. Guess why? I don't know the topic by heart, and since *you*
are the one who need the information and not me, I didn't see why I should
spend the time to read the topic for you. (But since I know that
predecessors to SQLCMD have supported such environment variables, I had
reason to expect that there is one.)

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

On Thu, 28 Oct 2010 23:33:12 +0200, Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

HA!

When I got Adobe Acrobat, there was approximately 7,000 pages of
documentation. I needed about 1/2 page of it for my integration.

Are you seriously suggesting that someone read every page before
getting going?

There is something to be said for organisation and
user-friendliness.

I do not even know where to find it. It is generally faster for
me to Google for something once I know about it than to try to find
something in the documentation.

CLUE: That might indicate to you that the documentation is not
beginner-friendly.

I had not previously used it, so I had no reason etc.

Note that I am speaking from the point of view of someone trying
to get started with this stuff. Bad documentation makes this much
more difficult than it needs to be.

Sincerely,

Gene Wirchenko

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
No, only the topic for SQLCMD.

And you do don't want to find it? You don't want to read documentation?
I'm sorry, but I have no sympathy for that attitude.

Books Online has an index. It has a search function. It has a table of
contents. With the slightest level of ambition you could easily find the
topic for SQLCMD.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

On Fri, 29 Oct 2010 09:19:02 +0200, Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

I have little tolerance for people who misstate other people
positions. There is a lot of documentation. I do not want to have to
read it all to get started. I want the relevant portion to get
oriented.

Did you cover the bit where I had no known reason for looking it
up? The tutorial implied that the bare command would just work.

Sincerely,

Gene Wirchenko

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
And I pointed you to do it. What more do want me to do? Fly over, and click
so you get the page in front of you? What is so difficult to use an index?
Really, Books Online is your biggest asset to get working with SQL Server,
so there is all reason to get acquainted with it. (And it's not that Books
Online is very SQL Server-specific, but it uses the same platform and
structure as MSDN Library. Well, at least up to VS 2008. What ships with
VS 2010 is a disaster.)

Are you referring to this?
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_5techref/html/00d57437-7a29-4da1-b639-ee990db055fb.htm

The first thing I see is the second note: "By default, SQL Server Express installs as the named instance *sqlexpress*."

So already there is a warning that you are not connecting to a default
instance.

Yes, that is a problem. Sometimes you need to read documentation more than
once to get the gist. That happens to me too.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx