Microsoft SQL Server Express, a freely downloadable and distributable version of Microsoft's SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller-scale applications.

learn more… | top users | synonyms

3
votes
2answers
7k views

How to install SQL Server Management Console in 2008 Express Version?

I started a dozen attempts to install the SQL Server Management Studio for the 2008 Express Version of SQL Server. What i use: Windows Vista 2007 SP 2 What i did: a) I downloaded the install file ...
3
votes
1answer
790 views

Removing Instances and SQL Server Express edition and going to Standard/Developer/Enterprise

I would like to move from SQL Server 2008 R2 Express to SQL Server 2008 R2 Developer or Enterprise. I just noticed that I have the following services running: SQL Server (MSSQLSERVER) SQL Server ...
10
votes
5answers
3k views

SQL Server 2008 Full Text Index Never Seems to Complete

Our website has a SQL Server 2008 R2 Express Edition database with full-text indexing for our website search. Each time a new record is added or updated in one of the indexed tables, the indexing ...
0
votes
1answer
1k views

sql server express admin tool portable/web

Is there a way to manage sql server express db, remotly, without installing a software. As a portable apps or a web admin (like phpmyadmin)
1
vote
1answer
124 views

sql server express install administration

is there a way to install sql server express without administration right? Is there a portable version? tank you (I need to test sql server on my computer before using the server but I dont have ...
4
votes
4answers
9k views

MySQL vs SQL Server Express (Compare Free DBMS)

I am searching for a comparison table between MySQL and SQL Server Express. Comparisons should include... Usage limit Tools (management/dev/backup/monitoring/...) "simultaneous connection" It's ...
3
votes
2answers
2k views

datatypes in sql server , difference between similar dataypes, numeric, money , decimal ,float

What datatypes could be given to this value --> 45.58 Could these be given: numeric money decimal float What's the difference then? Which one would be the best to use?
5
votes
3answers
6k views

Howto use Windows Authentication with SQL Server 2008 Express on a workgroup network?

I have two computers running SQL Server 2008 Express: c01 and c02, I setup both for remote connection using windows authentication. Worked fine for c02 but not for c01. This is the error message I'm ...