SQL Server

[J Staniforth]

I have been given the task of implementing a migration from Access to SQL Server 7. As I has been a couple of years since I've worked on SQLServer I feel I need some training (as I work for a charity we probably cannot afford to attend training courses).
Would anyone please suggest books and/or CBT's etc which are good to cover admin and/or programming of SQLServer7.
Thanks very much.
John.

[Clunietp]

The sql 7 books online are free from the microsoft web site, they are a great reference, but they are not tutorials. There are many web sites that have ADO and SQL (language) tutorials, however

If you'd like those links, let me know

Tom

[J Staniforth]

Thanks, I am confident with SQL - although any sites relating to Transact SQL would be good, as would the ADO sites.
I still find paper manuals easier for general study and have been impressed with CBTs in the past - so anyone with recommendations I would be grateful.
Thanks.

[Clunietp]

I'm don't know of any sites that go in-depth with T-SQL (but like I said, the free books online are GREAT)

Here are some ADO sites worth bookmarking:
http://msdn.microsoft.com/library/psdk/dasdk/mdat3n3g.htm
http://support.microsoft.com/support/kb/articles/Q185/0/33.ASP
http://support.microsoft.com/support/kb/articles/Q172/4/03.ASP
http://msdn.microsoft.com/library/techart/daotoadoupdate.htm
http://msdn.microsoft.com/library/psdk/dasdk/mdae82eb.htm
http://www.cybermagic.co.nz/winsoft/adofaq.htm

Tom

[JHausmann]

My favorite is an O'Reilly:

Transact -SQL Programming

Authors: Kevin Kilne, Lee Gould & Andrew Zanevsky

ISBN 1-56592-401-0