sql-server-express

Entity Framework won't persist data in SQL Express (MDF)

Hi guyz, I'm going crazy abou this, because I can't see what I'm doing wrong!!! Please help me!!! I was developing a application using Entity Framework and storing data in a .mdf database, my code can read the data, apparently it can save too, but only apparently. I get no erros, while the program is running it act like the data was sav...

How do I setup Teamcity to work with SQL Server 2005 Express?

Is this possible? I've followed the instructions from here (http://www.jetbrains.net/confluence/display/TCD4/Setting+up+an+External+Database#SettingupanExternalDatabase-MicrosoftSQLServer2005) but I keep getting an 404 Error when trying to access Teamcity. I've used the following syntax to configure jTDS: connectionUrl=jdbc:jtds:sqlser...

Change an SQL server express table name

Hi I am using Visual Studio 2008 and I have an .mdf in the app_data of my ASP.NET MVC project.. I was trying to change the name of a table through the properties in the server explorer but it is greyed out. Is it possible to change the name? I can see that you can copy the table but I am unsure on how to then paste a copy of it somewher...

ClickOnce, SQLExpress and predicting the Name

I have a winform app that will need to install SQLExpress with it. How can I predict what the SQL instance will be called so that my connection strings will all still work. ./SQLEXPRESS? username/SQLEXPRESS? or something else entirely? Thanks! ...

Connection String to Connect to .MDF

I've created a new project in VS2008, and added a .MDF file to the project. This is the first time I've tried to use the MDF files and .SQLEXPRESS databases (I've always used extenal Oracle servers in the past). I'm trying to document everything as I go, but I can't figure out what credentials are being used to connect to the .MDF file...

Why can I not connect to SQL on my computer?

I am using SQL Server 2008 express edition. I have connected before. Now I get this error message: TITLE: Connect to Server Cannot connect to GEF65439\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Serve...

SQL Server Express Performance breaks with large Logfiles

Hello all, we run since 2 years a small application on SQL Server 2005 Express Edition the Database has gown from 75 MB up to nearly 400MB within this time, the there isn't a big amount of data. But the log file has been arrived at 3,7GB now without changing Hardware, table structure or Program code we noted that the Import processes wh...

Configuring the Package.xml for SQL Express ClickOnce Pre-Requisite install ?

I have a winform app being installed by ClickOnce and I need to be able to enable Remote Connections in sqlexpress by default. Also, I need to make sure the local user has access to the SQL instance. How do I edit the manifest file? My app is a part of a Merge Replication topology. I inherited the DAL and until I change it I cannot ...

Is SQL Server Express' 4GB limit affected by FILESTREAM enabled columns?

I have read some conflicting reports on the net about whether the 4GB limit of SQL Server Express takes into account the contents of FILESTREAM. Can anyone say for certain citing official documentation whether SQL Server Express storage limit is affected by FILESTREAM contents? ...

"Unsolvable" bug in Visual Studio - how do I connect to SQL Server 2008 Express?

I've been struggling for some time now to be able to use the built-in functions in Visual Studio 2008 to handle *.mdf database files with SQL Server 2008 Express. I'm running on an x64-based system, and I've read that there is a known problem with this setup, but the hotfix has not solved my problems. Basically, what happens is that whe...

Using a Trigger to Email from SQL Express

I would like to send an email from SQL Server 2005 Express using a trigger. The solutions I have seen use the System Stored Procedures *xp_sendmail* or *sp_send_dbmail*, but these are not available under SQL Express (will only work under full SQL Server). Any suggestions would be appreciated. Thanks ...

How to install a custom desktop application database to SQL Express?

Hi, I have a WPF desktop application that uses a custom database for storage. I need to prepare a setup project (from Visual studio 2008) (full setup, not ClickOnce). I can add the to the list of prerequisites to the application and it does install during the setup of the application. My question is: How can I run a script during th...

Can Linq to SQL coexist with ADO in SQL Server Express?

I have a single-user Win Forms application that uses an SQL Server Express database via ADO.NET. I want to add more to my app, but by using Linq to Sql (while I learn Linq to Sql). I am unable to see the database in two places simultaneously. Either I can see it in the original code using ADO, or I can see it with the new code using L...

What are the advantages/disadvantages of using mdf vs sql db server

What is the difference between using SQL Express .mdf file and an actual SQL Server DB? Why wouldn't I use .mdf file for everything? Is there a size or performance limitation that would prompt me to use SQL Server DB? I currently use actual SQL Server DB's for every project I work on so I am just curious to know if an .mdf file might be ...

Slow Performance on Sql Express after inserting big chunks of data

Hello, We have noticed that our queries are running slower on databases that had big chunks of data added (bulk insert) when compared with databases that had the data added on record per record basis, but with similar amounts of data. We use Sql 2005 Express and we tried reindexing all indexes without any better results. Do you know of s...

SSIS with Sql Server 2005 express

Can we use SSIS with SQL Server (2005) Express as database? ...

ASP.NET MVC newbie: can't get aspnet_regsql.exe to work

Hi, I just installed Web Developer Express 2008 and the MVC framework (followed all the defaults, SQL Server Express was installed in the process). I followed the initial NerdDinner steps, created a database from the IDE and defined tables (worked fine). To further define my tables, which heavily rely on the user-base, I had to figure...

Windows Sharepoint Services and SQL Server express

Can I use sql express to run WSS on windows server 2008 and if I can would this be a wise move? ...

error while connecting sql express 2005 over the network

Hello Experts, I am getting an error while connecting sql express server 2005 over the network. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. I have tried fol...

Crystal Report: Unable to connect incorrect log on parameters

When printing a report, the user sometime have the following error: CrystalDecisions.CrystalReports.Engine.LogOnException: Error in File C:\DOCUME~1\carolec\LOCALS~1\Temp\temp_b117cc2e-c184-4556-a493-e04e6d4126fb {388C2B55-114E-4087-A22D-9289902AFDEB}.rpt: Unable to connect: incorrect log on parameters. ---> System.Runtime.InteropSe...