Top "Sql-server-express" questions

Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system.

Error: Failed to generate a user instance of SQL Server

I'm trying to connect to an MDF. I've even gone to the lengths of re-installing sql server express entirely (it …

visual-studio sql-server-express sql-server-2008-r2 user-instance
What happens when you hit the SQL Server Express 4GB / 10GB limit?

What kind of error occurs? What do users experience? Can you access the database using tools and what if you …

sql database sql-server-express
Backup failed for Server, The media is formatted to support 2 media families Error

Can any body tel me how to overcome this error when taking a backup in SQL Server 2008 Express? Backup failed …

sql tsql sql-server-express database-backups
How to check if SP1 for SQL Server 2008 R2 is already installed?

I have trouble figuring out if the SP1 is already installed. I don't think I could check it from the …

sql-server-express sql-server-2008-r2
LocalDB deployment on client PC

I am very intrigued by this new version of SQL Server Express. It's not clear (to me) what a setup …

sql-server installation sql-server-express sql-server-2012 localdb
How to set (combine) two primary keys in a table

For a small sales related application, we designed database using logical data model. Come to the stage to convert in …

ssms sql-server-express database composite-primary-key
No services listed when SQL Server Express 2008 R2 Installed on local computer

I cannot get my local computer to run SQL Server. I looked in the SQL Server configuration manager and noticed …

sql-server sql-server-express
How do I connect to the default instance of SQL Server if a "named instance" parameter is required?

I'm installing some software and I need to tell it to use the default instance of SQL Server, however the …

sql-server-2008 sql-server-express
sp_dropserver and sp_addserver not working

I am using SQL Server Express 2008 R2 and I wanted to change the instance name from "machine name"\SQLEXPRESS2008R2 …

sql-server sql-server-2008 sql-server-express