Good Afternoon:

We will soon be moving our on-line data base from Access to MSSQL.

Can anyone recommend any good books to get us started off with MSSQL? We 
were looking at "Beginning SQL Server 2000 Programming" by Wrox.

Just out of curiosity, does Enterprise Manager ship with all versions of 
MSSQL 2000?

Thanks,

Martin

Hi
Yes enterprise is there
The book is very nice
Covers stored procedures, xml  etc
Cheers
Nikos
At 11:39 =F0=EC 25/4/2002, you wrote:
>Good Afternoon:
>
>We will soon be moving our on-line data base from Access to MSSQL.
>
>Can anyone recommend any good books to get us started off with MSSQL? We
>were looking at "Beginning SQL Server 2000 Programming" by Wrox.
>
>Just out of curiosity, does Enterprise Manager ship with all versions of
>MSSQL 2000?
>
>Thanks,
>
>Martin
>
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or to
>unsubscribe send a blank email to 
>

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EC47.62B27902
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Your best choice for software is the SQL Server 2000 Developer Edition,
which is exactly the same as the Enterprise but you can only use it for
development, and it's much cheaper.

I have couple of SQL Server books but are not that great, so I'm not 
going
to suggest anything in particular

-----Original Message-----
From: Nikos [mailto:pappas@c...]
Sent: 25 April 2002 11:30
To: ASP Databases
Subject: [asp_databases] Re: Moving to MSSQL


Hi
Yes enterprise is there
The book is very nice
Covers stored procedures, xml  etc
Cheers
Nikos
At 11:39 =F0=EC 25/4/2002, you wrote:
>Good Afternoon:
>
>We will soon be moving our on-line data base from Access to MSSQL.
>
>Can anyone recommend any good books to get us started off with MSSQL?
>We
>were looking at "Beginning SQL Server 2000 Programming" by Wrox.
>
>Just out of curiosity, does Enterprise Manager ship with all versions
>of
>MSSQL 2000?
>
>Thanks,
>
>Martin
>
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or to
>unsubscribe send a blank email to 
>

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EC48.68C0C9B0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

i'd recommend the Wrox book: "Beginning SQL Server 2000 Programming" by R.
Dewson.

It comes with a 120 day evaluation ed. of SQL Server 2000 Enterprise Ed. and
has a good opening discussion about the various editions (what platform each
will run on etc).  It even deals with the installation.

Some of it's a little easy, but has been good for me coming from an Access
background.  If you fancy something a bit more taxing, i'm about to buy
Professional SQL Server 2000 by R. Viera (again frm Wrox) which get's great
reviews.

HTH,
Col

-----Original Message-----
From: Marios Adamantopoulos [mailto:mario@t...]
Sent: 25 April 2002 11:53
To: ASP Databases
Subject: [asp_databases] Re: Moving to MSSQL



Your best choice for software is the SQL Server 2000 Developer Edition,
which is exactly the same as the Enterprise but you can only use it for
development, and it's much cheaper.

I have couple of SQL Server books but are not that great, so I'm not going
to suggest anything in particular

-----Original Message-----
From: Nikos [ mailto:pappas@c... <mailto:pappas@c...> ]
 Sent: 25 April 2002 11:30
To: ASP Databases
Subject: [asp_databases] Re: Moving to MSSQL


Hi
Yes enterprise is there
The book is very nice
Covers stored procedures, xml  etc
Cheers
Nikos
At 11:39 =F0=EC 25/4/2002, you wrote:
>Good Afternoon:
>
>We will soon be moving our on-line data base from Access to MSSQL.
>
>Can anyone recommend any good books to get us started off with MSSQL?
>We
>were looking at "Beginning SQL Server 2000 Programming" by Wrox.
>
>Just out of curiosity, does Enterprise Manager ship with all versions
>of
>MSSQL 2000?
>
>Thanks,
>
>Martin
>
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp>  or to
>unsubscribe send a blank email to 
>


---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp>  or




*******

This message and any attachment are confidential and may be privileged or o
therwise protected from disclosure.  If you are not the intended recipient,
 please telephone or email the sender and delete this message and any attac
hment from your system.  If you are not the intended recipient you must not
 copy this message or attachment or disclose the contents to any other pers
on.

For further information about Clifford Chance please see our website at htt
p://www.cliffordchance.com or refer to any Clifford Chance office.

Enterprise Manager question is yes.
One way of thinking here is load the SQL Server software and create the
database, then go to the access side and create linked tables using an
ODBC.  Access can talk to MSSQL.  Then just go into query in Access and
read the access table and write the SQL table.  I found this much easier
than exporting and importing.

-----Original Message-----
From: Martin Lee [mailto:access@o...]
Sent: Thursday, April 25, 2002 4:40 AM
To: ASP Databases
Subject: [asp_databases] Moving to MSSQL


Good Afternoon:

We will soon be moving our on-line data base from Access to MSSQL.

Can anyone recommend any good books to get us started off with MSSQL? We

were looking at "Beginning SQL Server 2000 Programming" by Wrox.

Just out of curiosity, does Enterprise Manager ship with all versions of

MSSQL 2000?

Thanks,

Martin

Thanks Nikos,

will get myself a copy.

Martin

At 01:29  4/25/2002 +0300, you wrote:
>Hi
>Yes enterprise is there
>The book is very nice
>Covers stored procedures, xml  etc
>Cheers
>Nikos
>At 11:39 =F0=EC 25/4/2002, you wrote:
>>Good Afternoon:
>>
>>We will soon be moving our on-line data base from Access to MSSQL.
>>
>>Can anyone recommend any good books to get us started off with MSSQL? We

>>were looking at "Beginning SQL Server 2000 Programming" by Wrox.
>>
>>Just out of curiosity, does Enterprise Manager ship with all versions of

>>MSSQL 2000?
>>
>>Thanks,
>>
>>Martin
>>
>>
>>---
>>Change your mail options at http://p2p.wrox.com/manager.asp or to
>>unsubscribe send a blank email to 
>
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or to
>unsubscribe send a blank email to 

Thanks

At 11:53  4/25/2002 +0100, you wrote:

>Your best choice for software is the SQL Server 2000 Developer Edition,
>which is exactly the same as the Enterprise but you can only use it for
>development, and it's much cheaper.
>
>I have couple of SQL Server books but are not that great, so I'm not going

>to suggest anything in particular
>
>-----Original Message-----
>From: Nikos [<mailto:pappas@c...>mailto:pappas@c...]
>Sent: 25 April 2002 11:30
>To: ASP Databases
>Subject: [asp_databases] Re: Moving to MSSQL
>
>Hi
>Yes enterprise is there
>The book is very nice
>Covers stored procedures, xml  etc
>Cheers
>Nikos
>At 11:39 =F0=EC 25/4/2002, you wrote:
> >Good Afternoon:
> >
> >We will soon be moving our on-line data base from Access to MSSQL.
> >
> >Can anyone recommend any good books to get us started off with MSSQL?
> >We
> >were looking at "Beginning SQL Server 2000 Programming" by Wrox.
> >
> >Just out of curiosity, does Enterprise Manager ship with all versions
> >of
> >MSSQL 2000?
> >
> >Thanks,
> >
> >Martin
> >
> >
> <http://p2p.wrox.com/manager.asp>http://p2p.wrox.com/manager.asp or to
> >unsubscribe send a blank email to 
> >
>
><

Thanks Col:

Would you know if the evaluation ed. of SQL Server 2000 includes the
Personal Edition? I read that it is included as part of Enterprise and
Standard Editions, but could not find if was included in the Eval. Edition.

Will start off with "Beginning SQL Server 2000 Programming" :) And a later

stage will look into "Professional SQL Server 2000"

Regards,

Martin

At 12:00  4/25/2002 +0100, you wrote:
>i'd recommend the Wrox book: "Beginning SQL Server 2000 Programming" by R.

>Dewson.
>
>It comes with a 120 day evaluation ed. of SQL Server 2000 Enterprise Ed.
>and has a good opening discussion about the various editions (what
>platform each will run on etc).  It even deals with the installation.
>
>Some of it's a little easy, but has been good for me coming from an Access

>background.  If you fancy something a bit more taxing, i'm about to buy
>Professional SQL Server 2000 by R. Viera (again frm Wrox) which get's
>great reviews.
>
>HTH,
>Col
>-----Original Message-----
>From: Marios Adamantopoulos [mailto:mario@t...]
>Sent: 25 April 2002 11:53
>To: ASP Databases
>Subject: [asp_databases] Re: Moving to MSSQL
>
>Your best choice for software is the SQL Server 2000 Developer Edition,
>which is exactly the same as the Enterprise but you can only use it for
>development, and it's much cheaper.
>I have couple of SQL Server books but are not that great, so I'm not going

>to suggest anything in particular
>
>-----Original Message-----
>From: Nikos [<mailto:pappas@c...>mailto:pappas@c...]
>Sent: 25 April 2002 11:30
>To: ASP Databases
>Subject: [asp_databases] Re: Moving to MSSQL
>
>Hi
>Yes enterprise is there
>The book is very nice
>Covers stored procedures, xml  etc
>Cheers
>Nikos
>At 11:39 =F0=EC 25/4/2002, you wrote:
> >Good Afternoon:
> >
> >We will soon be moving our on-line data base from Access to MSSQL.
> >
> >Can anyone recommend any good books to get us started off with MSSQL?
> >We
> >were looking at "Beginning SQL Server 2000 Programming" by Wrox.
> >
> >Just out of curiosity, does Enterprise Manager ship with all versions
> >of
> >MSSQL 2000?
> >
> >Thanks,
> >
> >Martin
> >
> >
> <http://p2p.wrox.com/manager.asp>http://p2p.wrox.com/manager.asp or to
> >unsubscribe send a blank email to 
> >
>
><
>
>
>*******
>
>This message and any attachment are confidential and may be privileged or

>otherwise protected from disclosure. If you are not the intended
>recipient, please telephone or email the sender and delete this message
>and any attachment from your system. If you are not the intended recipient

>you must not copy this message or attachment or disclose the contents to
>any other person.
>
>For further information about Clifford Chance please see our website at
>http://www.cliffordchance.com or refer to any Clifford Chance office.

Thanks Ron:

am glad you brought this up:)

Basically our situation is that we will continue using Access in house and 
use MSSQL for
on-line data access.

Any ideas on options available to connect to the remote MSSQL database so 
we are able manage the MSSQL objects, since we won't have access to 
Enterprise Manager?

Thanks for the suggestion below, will use this to update records on the 
remote database.

Martin

At 07:47  4/25/2002 -0400, you wrote:
>Enterprise Manager question is yes.
>One way of thinking here is load the SQL Server software and create the
>database, then go to the access side and create linked tables using an
>ODBC.  Access can talk to MSSQL.  Then just go into query in Access and
>read the access table and write the SQL table.  I found this much easier
>than exporting and importing.
>
>-----Original Message-----
>From: Martin Lee [mailto:access@o...]
>Sent: Thursday, April 25, 2002 4:40 AM
>To: ASP Databases
>Subject: [asp_databases] Moving to MSSQL
>
>
>Good Afternoon:
>
>We will soon be moving our on-line data base from Access to MSSQL.
>
>Can anyone recommend any good books to get us started off with MSSQL? We
>
>were looking at "Beginning SQL Server 2000 Programming" by Wrox.
>
>Just out of curiosity, does Enterprise Manager ship with all versions of
>
>MSSQL 2000?
>
>Thanks,
>
>Martin
>
>
>