I installed SQL Server 2005 Express in a computer to replace MSDE.
Now I cannot connect it on my SQL Server Group with Server Enterprise
Manager.
Thanks

After upgradeing an existing MSDE instance to SQL Server express a backup
won't work.  When using the following statement:  "Backup Database APPDBTo
Disk='C:\Data\Archives\APPDB.bak' With Init"  we get the error "Invalid
column name 'mirror_count'". If we rebuild the MSDB by ...

Is there a specific newsgroup for SQL Server 2005 Express? Or is the
newsgroup to use?
Thanks
Stephen

I wrote an application in vb6 to install sql service pack 3a. I am running
this application from a cd. When I execute the setup from the application, I
get prompted to close the application that called the setup exe. Then, the
setup continues after I close the application, but ...

I have this distribution database (created via replication setup).
I have set aside 200 MB for data file in E:\ drive & 20 MB in C:\ drive for
log file using simple mode recovery
on the properties --> General tab of distribition it shows

I am running SQL Server 2000 sp3a , standard edtition.
I have ran a dbcc showcontig that shows the following :
DBCC SHOWCONTIG scanning 'tb_Options' table...
Table: 'tb_Options' (1079674894); index ID: 1, database ID: 6

In SQL Server 2005 Express the follwoing query produces the wrong result:
SELECT     CHANNEL, DURATION, STARTTIME
FROM         Recordings
WHERE     (STARTTIME > '12/27/05 00:00:00') AND (DURATION > '5')

I am installing SQL Server Express (2005) and have been given a warning that
my system does not meet the minimum hardware requirements.
I have the following:
768 MB RAM

I used the DBCC SHOWCONTIG on a database and it shows :
DBCC SHOWCONTIG scanning 'sysobjects' table...
Table: 'sysobjects' (1); index ID: 1, database ID: 8
TABLE level scan performed.

I connect to SQL server using SQLDMO to update the database and make many
Other tasks. I installed SqlServer2005 on a test server and I got an error
using the connect method of SQLDMO.
Is SQL Server 2005 is 100% compatible with old SQLDMO?

I write a program that use sqlclient to connect to SQL Server 2005 Database
so how can i run  this program on a computer that SQL Server 2005 is not
installed on it
cause it's too much for the customers to install SQL Server 2005 express

Administer SQL Server express?
I installed it and now what? How
to view/browse/create databases?
Any visual tools?

I have a statement table which stores customers latest statement details and
I retrieve them with the code below
I am using MSDE 2000
maxmonth, maxfn, maxweek are calculated dates

I have a statement table which stores customers latest statement details and
I retrieve them with the code below
maxmonth, maxfn, maxweek are calculated dates
sql = "Select * from [stheader] inner join [customer] on

I installed MS SQL Server 2005 Express edition. But couldnt find
SQLServerAgnet Service....
Dhiren