Steve,

Your tomorrow is here today:

http://www.bmwusa.com/bmwexperience/BmwInDepth/BMWTechnology/Luxury.htm?id=149

Met a guy in the building where I work, he has got one and is using it with an "unsupported" BT Cell phone, says that...

Unless you need to customize the email for each address, as long as the email list is less than 8000 characters, then simply use the ; delimited address list and...

/*

 Create a "semiphore" table to communicate with called AfterUpdateProcess

 Create a Trigger that notifies the "semiphore" table called tr_MyTable_Update

 Create a Stored Procedure usp_Launch_Process that reads the "semiphore" table

   and Launches...

You can split one file with ZIP and it will prompt for the chain to restore.

Can you say floppy diskette, good thing in those days we were only worried...

Here are some great free tools, I found this looking for a way to search the LAN for all of those instances of MSDE, did you know that Office 2003...

If you are using SQL Mail then you will also have to create an Outlook profile for the new login and reassign the SQL Mail profile in SQL Mail and SQL Server...

Search the scripts section of this web site for examples of scripts for your remaining questions. I posted:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=764

That should handle your restore for you and have seen others that...

SQL Server 2000 Standard Edition can use 2GB of memory, so to use 3GB you will have to update to the Enterprise version.

Set the /3GB setting in the boot.ini file...

Did you get the MDF from a CD? If so you did copy it to the hard drive, right? Check that ithe MDF file does not have the read only attribute set...

My experience is with Oracle 8i, and I found that for SQL Server 2000 sp3 access to Oracle, I had better results using the Microsoft Oracle drivers than the Oracle drivers...

Changing the default SQL Server port (1433) will require that all applications that access the server have their connection properties changed to <Server name or instance name or IP address>,<custom port number>.

Andy

Not unless your server Operating System is 64 bit, re: