>I would like to get a clarification regarding installation of the MSDE. My understanding is that when you insert the SQL Server CD to install, it offers a Server or Workstation installation. If you're running a workstation and not a server, it won't let you install the Server version. And that if you install the Workstation ( or Desktop ) version, that you are essentially installing the MSDE.
>
>Is this not correct and if not, what are the facts regarding this? If we install the Desktop version of SQL Server from the SQL Server CD and this is not the MSDE, then how is it different from the MSDE?
>
>Thanks,
>Bill

Yes, you are correct. MSDE is slightly different than desktop version of SQLServer. It has some limitation. You must download MSDE2000 from MS site, burn new CD and install it.