 |
|
8000XXXX Errors ASP.NET 2.0 Classic ASP 1.0
Databases Access DB & ADO General SQL Server & Access Articles MySQL Other Articles Schema Tutorials Sql Server 2000 Sql Server 2005 General Concepts Search Engine Optimization (SEO)Search
ASP FAQ Tutorials :: Databases :: Other Articles :: Where can I get this 'Books Online' documentation?
Where can I get this 'Books Online' documentation?
Books Online ("BOL") is the fundamental documentation tool for SQL Server. If you don't ever buy a single book on the product, this tool will still allow you to do your job.
SQL Server 2005
If you have SQL Server installed on your workstation, look under Start | Programs | Microsoft SQL Server 2005 | Documentation and Tutorials | SQL Server Books Online. If you chose not to install the documentation, or aren't running SQL Server 2005 locally, then you can download the standalone version of SQL Server 2005's Books Online here, though you may need to install the .NET 2.0 Framework first, if you don't already have it.
The December refresh is available here:
SQL Server 2005 Books Online
Note that the December refresh was not initially populated correctly to all servers, so if you have already downloaded it, you may still have the RTM version. The easiest way to tell is to run the MSI file. If you get the following dialog, you have the new version:
However, if you get a setup dialog offering you the options Modify, Repair, or Remove, unfortunately, you will need to go back and get the latest version.
Only download the September or June CTP versions of Books Online if you are still testing those pre-release versions.
If you want to use the online version of Books Online, it is not as easy to find:
Books Online
And for a quick overview of the topics that have been added/updated (there are a LOT!), see:
New and Updated Books Online Topics (...
SQL Server 2000
If you are running SQL Server 2000 on your machine, you can find it under Start | Programs | Microsoft SQL Server | Books Online. If you are developing from a machine that does not have SQL Server installed, you can download this resource from the following URL:
http://www.microsoft.com/downloads/detai...
Even if you have SQL Server installed and have Books Online available, you should download this update to replace your existing copy, as some things have changed or added (and won't be reflected in the original copy that is installed with SQL Server). Books Online is not part of the SP3a or SP4 packages, so even if your database engine is completely up to date, you most likely do not have the updated help content.
If you prefer to not download Books Online, you can still access the content—amazingly enough—online! The online version of SQL Server 2000's Books Online is here:
http://msdn.microsoft.com/library/en-us/...
Errors
Some users have complained about errors like the following, when clicking on links in Books Online:
After you've installed Books Online, you can avoid potential scripting errors within the content by downloading the HTMLHelp update found in KB #811630.
SQL Server 2005
If you have SQL Server installed on your workstation, look under Start | Programs | Microsoft SQL Server 2005 | Documentation and Tutorials | SQL Server Books Online. If you chose not to install the documentation, or aren't running SQL Server 2005 locally, then you can download the standalone version of SQL Server 2005's Books Online here, though you may need to install the .NET 2.0 Framework first, if you don't already have it.
The December refresh is available here:
SQL Server 2005 Books Online
Note that the December refresh was not initially populated correctly to all servers, so if you have already downloaded it, you may still have the RTM version. The easiest way to tell is to run the MSI file. If you get the following dialog, you have the new version:
However, if you get a setup dialog offering you the options Modify, Repair, or Remove, unfortunately, you will need to go back and get the latest version.
Only download the September or June CTP versions of Books Online if you are still testing those pre-release versions.
If you want to use the online version of Books Online, it is not as easy to find:
Books Online
And for a quick overview of the topics that have been added/updated (there are a LOT!), see:
New and Updated Books Online Topics (...
SQL Server 2000
If you are running SQL Server 2000 on your machine, you can find it under Start | Programs | Microsoft SQL Server | Books Online. If you are developing from a machine that does not have SQL Server installed, you can download this resource from the following URL:
http://www.microsoft.com/downloads/detai...
Even if you have SQL Server installed and have Books Online available, you should download this update to replace your existing copy, as some things have changed or added (and won't be reflected in the original copy that is installed with SQL Server). Books Online is not part of the SP3a or SP4 packages, so even if your database engine is completely up to date, you most likely do not have the updated help content.
If you prefer to not download Books Online, you can still access the content—amazingly enough—online! The online version of SQL Server 2000's Books Online is here:
http://msdn.microsoft.com/library/en-us/...
Errors
Some users have complained about errors like the following, when clicking on links in Books Online:
| A Runtime Error has occurred. Do you wish to debug? Line:0 Error: Object doesn't support this property or method. |
After you've installed Books Online, you can avoid potential scripting errors within the content by downloading the HTMLHelp update found in KB #811630.
Related Articles
How do I build a query with optional parameters? How do I calculate the median in a table? How do I create a store locator feature? How do I deal with MEMO, TEXT, HYPERLINK, and CURRENCY columns? How do I deal with multiple resultsets from a stored procedure? How do I debug my SQL statements? How do I determine if a column exists in a given table? How do I enable or disable connection pooling? How do I enumerate through the DSNs on a machine? How do I find a stored procedure containing <text>? How do I get a list of Access tables and their row counts? How do I get the latest version of the JET OLEDB drivers? How do I handle alphabetic paging? How do I handle BIT / BOOLEAN columns? How do I handle error checking in a stored procedure? How do I ignore common words in a search? How do I page through a recordset? How do I present one-to-many relationships in my ASP page? How do I prevent duplicates in a table? How do I prevent my ASP pages from waiting for backend activity? How do I prevent NULLs in my database from mucking up my HTML? How do I protect my Access database (MDB file)? How do I protect my stored procedure code? How do I protect myself against the W32.Slammer worm? How do I remove duplicates from a table? How do I rename a column? How do I retrieve a random record? How do I return row numbers with my query? How do I send a database query to a text file? How do I simulate an array inside a stored procedure? How do I solve 'Could not find installable ISAM' errors? How do I solve 'Operation must use an updateable query' errors? How do I temporarily disable a trigger? How do I use a SELECT list alias in the WHERE or GROUP BY clause? How do I use a variable in an ORDER BY clause? Should I index my database table(s), and if so, how? Should I store images in the database or the filesystem? Should I use a #temp table or a @table variable? Should I use a view, a stored procedure, or a user-defined function? Should I use recordset iteration, or GetRows(), or GetString()? What are all these dt_ stored procedures, and can I remove them? What are the limitations of MS Access? What are the limitations of MSDE? What are the valid styles for converting datetime to string? What datatype should I use for my character-based database columns? What datatype should I use for numeric columns? What does "ambiguous column name" mean? What is this 'Multiple-step OLE DB' error? What is wrong with 'SELECT *'? What naming convention should I use in my database? What should I choose for my primary key? What should my connection string look like? When should I use CreateObject to create my recordset objects? Where do I get MSDE? Which database platform should I use for my ASP application? Which tool should I use: Enterprise Manager or Query Analyzer? Why are there gaps in my IDENTITY / AUTOINCREMENT column? Why can I not 'open a database created with a previous version...'? Why can't I access a database or text file on another server? Why can't I use the TOP keyword? Why do I get 'Argument data type text is invalid for argument [...]'? Why do I get 'Not enough space on temporary disk' errors? Why does ASP give me ActiveX errors when connecting to a database? Should I use COALESCE() or ISNULL()? Where can I get basic info about using stored procedures?