I've installed SQL Server Express 2005 for one application and found
out now that one needs to update indexes from time to time. Other
databases do this automatically. How can I achieve this with the SQL
Server Express? What do I need and how to do it? I'm running it on

Hello all,
I have two computers in LAN. Both computers are visible
one to another. First computer has MSDE installed on it.
Second cumputer runs application that needs to connect to

Here is my background.  I am using the MSDE 2000 MS SQL.  I have a table with
1,189,032 records in it.  When I connect to the SQL server, and run a simple
query, select * from testRecs where startdate >= '6/7/2009' and enddate <=
'6/8/2009', runnin the execution plan, it takes ...

I have a question. How to move data basefrom one PCto another PC. I tried
to backup database the from machine1. then copy to local drive of machine 2
then restore it to machine 2. It fails.  It fails. why?
Thank you for your help.

Does SQL Express 2005 have any limitations on the number of network cards
that may be installed in the PC? A customer of ours has an application that
uses SQL Express and has recently installed a separate network card to
enabled him to connect to a different network. Our ...