Enterprise Manager

S

Sharon

I have just had Enterprise Manager software installed on my computer. Can
anyone tell me a good place to start learning how to use it? Thanks in
advance for any information.
 
R

Rick B

No idea what that is. This is an ACCESS (database appliaction that is part
of Office Profesional) newsgroup. If you need help using Microsoft Access,
then you are in the right place.
 
M

Mike Labosh

I have just had Enterprise Manager software installed on my computer. Can
anyone tell me a good place to start learning how to use it? Thanks in
advance for any information.

If you got Enterprise Manager, you may have also gotten Query Analyzer, SQL
Server Books Online and a couple other gadgets.

These things are the "client tools" for Microsoft SQL Server, a huge
corporate-wide high-performance database server.

Enterprise Manager lets you interact with SQL Servers, databases, and the
objects that are in them. You can create and alter tables, stored
procedures (What Access people call Action Queries) Views (What Access
people call Select Queries) and SQL Functions (Access doesn't have this).
You can also define custom data types, create user logins, deal with
security and so forth.

Query Analyzer is a utility that works similar to working in an Access Query
in SQL View. But it has gobbles of other features.

Where you want to begin is with the SQL Server Books Online help file.
Begin by browsing through the help topics in the contents pane.

--
Peace & happy computing,

Mike Labosh, MCSD
"Working here is like living inside a Salvador Dali painting." -- Me. Yeah,
ME! [Oh fer cryin out loud]
 
S

Sharon

Thank you for the information and your patience. Have a good weekend! Thanks.
--
S


Mike Labosh said:
I have just had Enterprise Manager software installed on my computer. Can
anyone tell me a good place to start learning how to use it? Thanks in
advance for any information.

If you got Enterprise Manager, you may have also gotten Query Analyzer, SQL
Server Books Online and a couple other gadgets.

These things are the "client tools" for Microsoft SQL Server, a huge
corporate-wide high-performance database server.

Enterprise Manager lets you interact with SQL Servers, databases, and the
objects that are in them. You can create and alter tables, stored
procedures (What Access people call Action Queries) Views (What Access
people call Select Queries) and SQL Functions (Access doesn't have this).
You can also define custom data types, create user logins, deal with
security and so forth.

Query Analyzer is a utility that works similar to working in an Access Query
in SQL View. But it has gobbles of other features.

Where you want to begin is with the SQL Server Books Online help file.
Begin by browsing through the help topics in the contents pane.

--
Peace & happy computing,

Mike Labosh, MCSD
"Working here is like living inside a Salvador Dali painting." -- Me. Yeah,
ME! [Oh fer cryin out loud]
 
J

James A. Fortune

Sharon said:
I have just had Enterprise Manager software installed on my computer. Can
anyone tell me a good place to start learning how to use it? Thanks in
advance for any information.

A good training ground for SQL Server, IMO, is Access. Anyone
proficient at programming databases may discover reasons to go beyond
Access' capabilities here:

http://www.microsoft.com/sql/evaluation/overview/default.mspx#ECAA

Also, Access can link to data stored in SQL Server tables. The SQL
Server Books Online is a free download that I've installed and read but
I don't have the link handy. Again I say, "Start with Access."

James A. Fortune
 
Top