help files in English (QA)

Dear fellows,
From my workstation I've got QA and its help files, in spanish. I'd like to
have in english and so I would avoid to use Terminal Server (against
production servers) for consult that info in English...
Is there any way for to change this?
Thanks a lot for any input or advice,
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)The support files for Books Online are stored in the following location:
C:\Program Files\Microsoft SQL Server\80\Tools\Books
The link is as follows:
C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL
Server\80\Tools\Books\SQL80.col"
You could create a new folder like the following and copy the files from
another workstation that had an Engligh install:
C:\Program Files\Microsoft SQL Server\80\Tools\Books_EN
Once done, create a new shortcut on your desktop for the following:
C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL
Server\80\Tools\Books_EN\SQL80.col"
I would expect that only one version of BOL can be linked with QA, EM and
the other client tools, so you would need to access the Engligh verison of
the documentation using the above shortcut.
Also, there is MSDN.com
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:E90A46EB-EBFD-4967-ADF9-FD5030B0F1A7@.microsoft.com...
> Dear fellows,
> From my workstation I've got QA and its help files, in spanish. I'd like
> to
> have in english and so I would avoid to use Terminal Server (against
> production servers) for consult that info in English...
> Is there any way for to change this?
> Thanks a lot for any input or advice,
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''s hard to provide information
> without seeing the code. location: Alicante (ES)|||hi JT,
Have done but not successful results. my workstaton is in spanish. Maybe
that's the reason. I have 'Archivos de programa' instead of 'Program Files'
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)
"JT" wrote:

> The support files for Books Online are stored in the following location:
> C:\Program Files\Microsoft SQL Server\80\Tools\Books
> The link is as follows:
> C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL
> Server\80\Tools\Books\SQL80.col"
> You could create a new folder like the following and copy the files from
> another workstation that had an Engligh install:
> C:\Program Files\Microsoft SQL Server\80\Tools\Books_EN
> Once done, create a new shortcut on your desktop for the following:
> C:\WINDOWS\hh.exe "C:\Program Files\Microsoft SQL
> Server\80\Tools\Books_EN\SQL80.col"
> I would expect that only one version of BOL can be linked with QA, EM and
> the other client tools, so you would need to access the Engligh verison of
> the documentation using the above shortcut.
> Also, there is MSDN.com
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:E90A46EB-EBFD-4967-ADF9-FD5030B0F1A7@.microsoft.com...
>
>|||I don't see why an Engligh (.chm) help file can't be opened; adjust the
folder path to the files as needed. The Engligh characterset is part of a
Spanish language install of Windows.
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:577F1495-5E28-4201-A399-B901E8A13D0C@.microsoft.com...
> hi JT,
> Have done but not successful results. my workstaton is in spanish. Maybe
> that's the reason. I have 'Archivos de programa' instead of 'Program
> Files'
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''s hard to provide information
> without seeing the code. location: Alicante (ES)
>
> "JT" wrote:
>

Help a Newbie Out... SQL Learning...

I am attanding school for Database Administration, still taking all the
English Classes and other requirements, but soon that will be over
with. I wanted to get a head start with SQL, I installed SQL 2005
Server Standard Edition, not the Enterprise one.
I installed it on my Laptop for learning purposes running Windows XP
Pro SP2, and it runs just fine. So I used some of the Tools to view
the tree of everything, the Tables and all that, but here is my
question.
Before I go on, the only experiance with SQL I have is from Linux,
working with the MySQL Open Source package, so I know some of the
commands for viewing Tables and all that and creating them, but nothing
too complex past this point, no scripting, however I do know VBA for
Excel and some with Access.
For someone new like me, where should I start ?
I have lots of Excel experiance, am good at it and also am good in
Access.
With Access you can create your Tables and put the data in there, the
FORMs and all that.
But with SQL, I am confused as to how to create the TABLES with the set
of tools that came with it. Is there a totally different product that
I must use to create the tables on the locahost for learning purposes
or what ?
Which books should I buy ?
Thanks for your input!!!!I figured out how to create a new Database using the SQL Server
Management Studio Tool, and then I created a Table too and now I am
creating the Table contents, different Columns.
What is the best way to enter the data into the Table ?
Are there like FORMs that exists, where once the Table is setup, people
can enter the datainto the Table remotely, say within the local
network, here where I work ?
Thanks!!!
RompStar wrote:
> I am attanding school for Database Administration, still taking all the
> English Classes and other requirements, but soon that will be over
> with. I wanted to get a head start with SQL, I installed SQL 2005
> Server Standard Edition, not the Enterprise one.
> I installed it on my Laptop for learning purposes running Windows XP
> Pro SP2, and it runs just fine. So I used some of the Tools to view
> the tree of everything, the Tables and all that, but here is my
> question.
> Before I go on, the only experiance with SQL I have is from Linux,
> working with the MySQL Open Source package, so I know some of the
> commands for viewing Tables and all that and creating them, but nothing
> too complex past this point, no scripting, however I do know VBA for
> Excel and some with Access.
> For someone new like me, where should I start ?
> I have lots of Excel experiance, am good at it and also am good in
> Access.
> With Access you can create your Tables and put the data in there, the
> FORMs and all that.
> But with SQL, I am confused as to how to create the TABLES with the set
> of tools that came with it. Is there a totally different product that
> I must use to create the tables on the locahost for learning purposes
> or what ?
> Which books should I buy ?
> Thanks for your input!!!!|||On 12 Sep 2006 15:49:44 -0700, "RompStar" <rmiecznik@.comcast.net>
wrote:
>But with SQL, I am confused as to how to create the TABLES with the set
>of tools that came with it. Is there a totally different product that
>I must use to create the tables on the locahost for learning purposes
>or what ?
You should learn to create tables using the query window built into
Management Studio. Forget the GUI tools for building tables, at least
until you can do them easily as straight CREATE TABLE commands. The
same goes for creating views and stored procedures. Anyone who
intends to function as a DBA has to be able to work that way. So open
up the Books on Line, and start learning the command syntax.
The GUI tools are fine for viewing what objects exist and how they are
defined, however.
Roy Harvey
Beacon Falls, CT|||RompStar wrote:
> I figured out how to create a new Database using the SQL Server
> Management Studio Tool, and then I created a Table too and now I am
> creating the Table contents, different Columns.
> What is the best way to enter the data into the Table ?
> Are there like FORMs that exists, where once the Table is setup, people
> can enter the datainto the Table remotely, say within the local
> network, here where I work ?
> Thanks!!!
>
> RompStar wrote:
>> I am attanding school for Database Administration, still taking all the
>> English Classes and other requirements, but soon that will be over
>> with. I wanted to get a head start with SQL, I installed SQL 2005
>> Server Standard Edition, not the Enterprise one.
>> I installed it on my Laptop for learning purposes running Windows XP
>> Pro SP2, and it runs just fine. So I used some of the Tools to view
>> the tree of everything, the Tables and all that, but here is my
>> question.
>> Before I go on, the only experiance with SQL I have is from Linux,
>> working with the MySQL Open Source package, so I know some of the
>> commands for viewing Tables and all that and creating them, but nothing
>> too complex past this point, no scripting, however I do know VBA for
>> Excel and some with Access.
>> For someone new like me, where should I start ?
>> I have lots of Excel experiance, am good at it and also am good in
>> Access.
>> With Access you can create your Tables and put the data in there, the
>> FORMs and all that.
>> But with SQL, I am confused as to how to create the TABLES with the set
>> of tools that came with it. Is there a totally different product that
>> I must use to create the tables on the locahost for learning purposes
>> or what ?
>> Which books should I buy ?
>> Thanks for your input!!!!
>
Hi
SQL Server it self hasn't got any "input" interface for users. You can
to some extend work with data from SQL Server Management Studio and you
can write all the queries you like from Query Analyzer (or Query Editor
as I think it's called in Management Studio) but that's not for regular
users.
Instead you'll have to either create some forms etc. in Access and then
use a SQL server Table as storage or you'll have to write your own
application.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator|||Great, good info. I am not afraid to use commands, that's all one uses
when running servers using Sun OS and Linux, I am used to running that
for over 12 years.
I prefer command line anyways.
Which books are boog for beginners, I want to learn all the syntax, and
whatever programming tools they offer, like in Access I can do VBA, and
examples on how to develop different FORMs.
Please recommend books for a Newbie, I want to do very well in all my
classes, thus why I am getting a head starts, I won't start my classes
for about another 6 months.
Thanks!
Steen Persson (DK) wrote:
> RompStar wrote:
> > I figured out how to create a new Database using the SQL Server
> > Management Studio Tool, and then I created a Table too and now I am
> > creating the Table contents, different Columns.
> >
> > What is the best way to enter the data into the Table ?
> >
> > Are there like FORMs that exists, where once the Table is setup, people
> > can enter the datainto the Table remotely, say within the local
> > network, here where I work ?
> >
> > Thanks!!!
> >
> >
> > RompStar wrote:
> >
> >> I am attanding school for Database Administration, still taking all the
> >> English Classes and other requirements, but soon that will be over
> >> with. I wanted to get a head start with SQL, I installed SQL 2005
> >> Server Standard Edition, not the Enterprise one.
> >>
> >> I installed it on my Laptop for learning purposes running Windows XP
> >> Pro SP2, and it runs just fine. So I used some of the Tools to view
> >> the tree of everything, the Tables and all that, but here is my
> >> question.
> >>
> >> Before I go on, the only experiance with SQL I have is from Linux,
> >> working with the MySQL Open Source package, so I know some of the
> >> commands for viewing Tables and all that and creating them, but nothing
> >> too complex past this point, no scripting, however I do know VBA for
> >> Excel and some with Access.
> >>
> >> For someone new like me, where should I start ?
> >>
> >> I have lots of Excel experiance, am good at it and also am good in
> >> Access.
> >>
> >> With Access you can create your Tables and put the data in there, the
> >> FORMs and all that.
> >>
> >> But with SQL, I am confused as to how to create the TABLES with the set
> >> of tools that came with it. Is there a totally different product that
> >> I must use to create the tables on the locahost for learning purposes
> >> or what ?
> >>
> >> Which books should I buy ?
> >>
> >> Thanks for your input!!!!
> >>
> >
> >
> Hi
> SQL Server it self hasn't got any "input" interface for users. You can
> to some extend work with data from SQL Server Management Studio and you
> can write all the queries you like from Query Analyzer (or Query Editor
> as I think it's called in Management Studio) but that's not for regular
> users.
> Instead you'll have to either create some forms etc. in Access and then
> use a SQL server Table as storage or you'll have to write your own
> application.
>
> --
> Regards
> Steen Schl=FCter Persson
> Databaseadministrator / Systemadministrator|||"RompStar" <rmiecznik@.comcast.net> wrote in message
news:1158102439.117633.76600@.m73g2000cwd.googlegroups.com...
> Are there like FORMs that exists, where once the Table is setup, people
> can enter the datainto the Table remotely, say within the local
> network, here where I work ?
If you have a background in Access, you might check out Access Data
Projects. Basically, you use Access as a front-end interface to SQL's
back-end. It is similar to a 'regular' Access MDB database.
Jonathan