I'm trying to move my database.mdf file from a development environment to a SQL Server Express server that is hosted on my VPS - but I can't figure out how to attach the file to my database server. Help! ...
How do I insert Chinese characters into a SQLExpress text field? I'm using SQL Express from VS 2008. When I add Chinese characters, either via an import app I wrote or by pasting them in from the data view inside Visual Studio, they end up as question marks. ...
I have a simple app that uses an SQL Express 2005 database. When the user closes the app, I want to give the option to back up the database by making a copy in another directory. However, when I try to do it, I get "The process cannot access the file '...\Pricing.MDF' because it is being used by another process." I closed the connecti...
Greetings – To automate testing of our database SPROCs, we’ve been using dynamically created databases inside of a User Instance. This has been working very well – the build server and, until very recently, all the developers could all run the tests. However, one of our developer machines is now returning the following error when we tr...
When restoring a full DB backup to a different SQL Server 2005 Express server, I receive the following message: The file or filegroup "mydatabase_log" cannot be selected for this operation. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3219) I've checked the restore options to make sure that file...
I have this code, running parallel in two separate threads. It works fine for a few times, but at some random point it throws InvalidOperationException: The transaction is either not associated with the current connection or has been completed. At the point of exception, I am looking inside the transaction with visual studio and verify...
Working on a common codebase, one developer is running SQL Server Express 2005 and the other 2 are running SQL Server 2005. Everything is working fine, but the connection strings differ. To maintain common configuration and build scripts we're looking to mask "localhost\sqlexpress" to just "localhost" like the other 2 developers. Can th...
Hi all, I am having an odd problem with my SQL Server express 2005 DB. It is running on a 2003 server. With VS2005 I can access the db without any problem. But when I try and run the application I get: Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'......... .ldf may be incorre...
I plan on installing Multiple Instances of MS SQL EXPRESS on my Development Server. I am hoping this will let me get around the limitations of SQL EXPRESS: 1 GB of RAM, 1 CPU Database size max 4 GB [I understand and wish that I could afford a full licence version of SQL Server.] So, would this work? Would each instance have the...
I'm running a small web application with SQL server express (2005) as backend. I can create a backup with a SQL script, however, I'd like to schedule this on a daily basis. As extra option (should-have) I'd like to keep only the last X backups (for space-saving reasons obviously) Any pointers? [edit] SQL server agent is unavailable in ...
I have Visual Studio 2008 and SQL Server 2008 Developer Edition installed on a Windows XP machine. I get this error when trying to work on a Test Web Application: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instan...
I am trying to use the aspnet___regsql utility to install all the membership tables in a database on my local SQL Express 2008 instance. I can connect without problems in Management Studio, but when I try to list the databases in the aspnet_regsql interface i get an error message saying: Failed to query a list of database names from the...
I've been experimenting with ASP.Net MVC, and have come across a problem that is probably not specifically MVC related. But I cannot get the authentication in the default MVC application (the one created by the wizard when you create a new MVC project) to work properly under IIS 7 on Windows 7. If I run under the Visual Studio environme...
Hi, Is it possible to get sql profiler for sql2008 for free or you have to have a license to get it? i.e. it won't work with sql express ...
Has anybody used a local instance of SQLEXPRESS on a web server for serving up read only/mostly content? It seems a read-only database with no referential integrity, denormalized tables, indexes galore, etc. could perform well. Is this a completely horrible idea? And if so, why? ...
In your development environment, do you install a local SQL express or a dedicated SQL server? What are the pro/con's of these two options? From my own experience so far: Local installation slows down the own development workstation due to resource consumption Local installation is easier to debug/manage Dedicated installation eases c...
Should the ASPNETDB be left in default app folder created by Visual Studio when deploying on webserver? I have another DB that is in the mssql data folder, should that be placed in same directory as well? Im not clear on whether it matters one way or the other. ...
I am using SQL Express 2008 as a backend for a web application, the problem is the web application is used during business hours so sometimes during lunch or break time when there is no users logged in for a 20 minute period SQL express will kick into idle mode and free its cache. I am aware of this because it logs something like: S...
I'm currently developing an application that needs to store data in it's on database, I'm currently using SQL Server Express 2005 with Advanced Services (because we need full text search capabilities). Local company lore says there have been all sorts of strange problems some years ago when two products used MS SQL Server with the defau...
Can I use SQL Express for commercial use? or it should be only used for personal development and learning purposes? What are the conditions if I can use it for commercial purpose? ...