Have you looked at SQL mail? There is a COTS package called Postie that will send mail too. SQL mail requires Outlook to be installed on the SQL Server. Check also DatabaseMail with SQL 2005

PLESE RE_POST IN PROPER AREA. THAT IS NOT A SQL QUESTION

Not an issue unless the database is set to be case sensitive. Other wise you can do this select * from user where UPPER(id) = UPPER('aaa') and UPPER(pass)= UPPER('hello');

You caqn not have more that one identity column per table. The way to handle what you are attempting may be to insert the new record, get the identity using the SCOPE_IDENTITY() function then updating the record with that value

Look at Books online. There is a full explanation there. You can also go to MSDN and search for linked servers

There are a couple of solutions I can tell you about. It really depends on what your goal is Diagram the tables using SQL Server enterprise. This will provide you with an ER document based on the database. The downside of this method is its not the prettiest format. Microsoft Visio has a database stencil that will allow you to reverse engineer a database but once the database has been reverse engineered, you will have to do some work to make the diagrams readable for presentation. Computer Associates ERWIN is by far one of the leading tools on the market. You can created database schema's using the tool and you can reverse engineer SQL Server as well as many other types of databases. The advantage of this tool is it creates very nice presentation diagrams, provides a method to create and maintain a data dictionary and also provides many reports about the database that your users may find informational. The greatest feature I found is the ability to compare a model against an existing database. The tool will compare the model against an existing database and provide you scripts to either bring the model to the level of the database or update the database to the level of the model. The biggest disadvantage of this product is the cost. I believe its about 5k but to be sure check with CA. If you have no budget, the diagrammer in SQL Server is your best choice, low budget I would use Visio but if you have a big budget and can justify the purchase I would reccomend ERWIN Hope this helps Steve Martin, Symantec, Inc