I was just wandering if it is possible to send e-mail through MSDE.  I
have several jobs running on the MSDE instance that i would like e-
mail notification for when they are completed.
I dont seem to be able to set up an SQL Mail profile as it is greyed

I am running bcm2007 / sql2005 express sp2.  I am unable to customize a page
within BCM.  How do I give myself permissions to be able to make
customizations
Thanks

Hi, we have an application, that runs on 1000 PC's in different part of the
world, and we are using MSDE to contain Configurations data.
We are refreshing the data, by restoring a backup, made on our main server.
We would like to upgrade the main server from MSSQL2000 to MSSQL2005.

I imported dbf files (dbase) into an msde database.
I see the tables with the data in the msde database. The data is identical.
The only change made to the code is in the DSN assignment in the Recordset's
GetDefaultConnect(),

Currently, PaymentDate in my table is a SMALLDATETIME and NULL is allowed.  I
would like to alter PaymentDate column to be NOT NULL and set its default
value to current date.  
I am using the following osql command but it generated an error; could

I have a sql server 2005 based MyDB.mdf and MyDB.log in c:\MyData folder. All
client components are installed on my machine but do not have Management
Studio.
How do I ALTER a table property in this database either by using osql or

I had to reinstall sql 2005 server and express.etc
what services should I leave running so I can actually get the data itself.
when I tried to fill a dataset in .net 2 vb or preview in visual basic 2005
express database explorer, I get

I'm trying to install MSDE2000A on a windows 2003 server sp2 via the
command:
setup.exe INSTANCENAME=SOPHOS SAPWD=3fishylip DISABLENETWORKPROTOCOLS=0
/L*v C:\MSDE_LOG.TXT

I have to write a program which i compatible with both access and msde; is
there a way of writing the following SQL query so that it works in both
access and msde?
This works in access...