It is important that you read the pre-installation notes make sure you perform any pre-installation requirements (like stopping any sql services running and uninstalling previous versions) Especially since you have an older version already installed.

http://msdn.microsoft.com/vstudio/express/support/
http://msdn.microsoft.com/vstudio/express/sql/download/
http://www.microsoft.com/downloads/details.aspx?FamilyID=b0167129-5ac8-49c4-90bd-0493f3773081&DisplayLang=en#QuickInfoContainer

>Cetin & Dan - Thanks for your input.
>
>Well, it seems somewhere along the way I picked up a copy of MSSQL server. Perhaps its the lite version that comes with VFP 9? In any case, I have an icon in my tray that brings up a control window for SQL Server and it says the service is running. But that's all I know. I can't find any means to access the service or set up a table in it or ?? Where do I go from here?
>
>In a related matter. Once the database is setup as a client-server relationship, will it be possible to interact with it via means other than record data? Specifically, can a stored procedure in the database send messages back to the client that contain info such as "That record is already in the database."?
>
>Thanks again.
>- Don
>
>>No. But it would be a dandy idea to set up some version of SQL-server on your local machine. VFP9 ships with a copy of MSDE (which is SQL-server in drag, and is now known as SQL-Server Lite).
>>
>>"Remote data" does NOT mean the data is located on a remote machine. It's just outside the VFP environment. It can be in a different environment on your own workstation.
>>
>>Dan
>>
>>
>>>If I wanted to learn how to interact with a backside server like SQL Server, would it be a good idea to simulate this experience with VFP? (Seeing as though there are no SQL Server databases available at the moment.)
>>>
>>>If so, is there a white paper available that would provide the basics of how to set it up and understand it?
>>>
>>>Thanks for any input.
>>>-Don