This article discusses the details about SQL Server Alerts.It is not possible for DBAs to check continuously for every special condition. There may be special conditions in which DBA wants to do some automatic management or get notified. SQL Server has feature called ALERTS to cope with this requirement.

Features:

Table Report - Quickly bring printable info about a table
Tabbed Windows - VS.NET style editor windows
User Functions - see what user functions are in your databases
Stop Button - allowing you to stop execution of an SQL statement (finally!)
System Functions - displayed in database explorer. This is quite handy.

SQL Server 2008 provides several enhancements over SQL Server 2000 in terms of XML support and some enhancements over SQL Server 2005. While much of the backward-compatible XML-specific functionality from SQL Server 2000 is available in SQL Server 2008, most of it has been deprecated in favor of the new features and functionality.

The script in a SQL Server database full backup, and backup documents passed to another machine. Backup file naming rules: the database name _ timestamp. BAK.
environment: windows 2003 server  SQL Server 2000

SQL Server’s query functionality can be extended by using T-SQL. It can encapsulate common tasks and make it easier to maintain and perform them. It in effect allows you to write SQL batches that perform common tasks and store those batches directly in SQL Server for later reuse.

 XML  into  SQL Server a number of ways, here one of three kinds:
   1. COM interface loading capacity. If you need to document the entities and attributes into to the table, the fastest way is to use SQL Server 2000 Extensible Markup Language 3.0 Service Pack 1 (SQLXML 3.0 SP1) provides high-capacity load COM interfaces. Large state COM interfaces included in the SQLXML 3.0 SP1 in the free download.

Ineeded to convert existing SQL Server databases to SQLite databases as part of DB migration program and did not find any decent free converter to do the job. my attempt to solve the problem. I should warn you though that I did not have much time to test it on too many databases. In any case - the source code is very well documented and easy to understand .