Is SQL Express 2008 available for corporate, business and government use? Are there restrictions I am not reading about? I know it is free, but I just want to make sure I am not stepping on any terms of use. Maybe I missed it when I clicked around Microsoft’s site, but I didn't see any terms referencing use restrictions specifically. I...
Hi I'm using VWD 2008 (SP1) and SQLExpress 2008. I'm creating a database first and then looking at using DynamicDataControls (seem useful and staright foward for a beginner like me). Within VWD I created a new Dynamic Data Web Application. Then I added a new SQL database item. I noticed that this doesn't include stored procedures or......
I have SQL Server 2005 installed and VS 2008 on Windows XP Pro SP2. I am building a VB.Net windows application and trying to add a .mdf database to it as a local db inside the project. But i always receive this message: "Local database file Failed to generate a user instance of SQL Server due to a failure in starting the process for ...
In .NET, you can open a SQL Express database simply by attaching the database MDF file in the connection string (that is, you don't have to have any server software installed, it just attaches to the MDF file on the fly). When an application does this, does it obtain an exclusive lock on the database file? Or, can a second application ...
Is it possible to connect to an instance of sql express via another computer on my home network. I have tried but the connection always fails. What settings should I be looking out for? What are good words to search on? I have enabled TCP/IP Always get a message saying 'SQL servers does not exist or access is denied' thanks ...
I have an application running on mssql 2005 express and I want to install the full text search. What should I do? Can I download the full text search service and install it separately. ...
How do you change the Language in SQL Express (2008) to another language like English? ...
Hi, I need a safe (i.e consistent, robust) way of detecting whether or not the sql server I'm accessing is Sql Express. I think I'd prefer to be able to do this from TSQL, since I already have a connection string and all the libraries I need to execute TSQL (this should help avoid issues with whether or not WMI is installed/running, the...
SQL Express 2005 is running locally. I have a project written by another person running on the same machine. All I want to do is connect to it, can't be that hard right? This is the one I use in my old classic ASP code to hit another database running on the same instance: Provider=SQLOLEDB;Data Source=MYLAPTOP\MSSMLBIZ;Persist Security...
What did Microsoft rename DTS to for SQL Server 2005 Express Edition? Where is the download link to the SQL Server 2005 Express Edition DTS utility? i've been searching for half an hour, and i can't find a definitive answer. i need to import data from a data source into an SQL Server 2005 Express Edition database. ...
At the company i develop, developers typically run databases on their laptops. We also have an instance of a SQL Server 2005 and SQL Server 2000 servers running as virtual machines, under an MSDN license. I am not a MSDN guru and not really familiar with the ins-and-outs of MSDN, so the my questions are as follows. Would each develope...
I'm running an SQL Server express 2005 database inside a guest OS that I'm trying to connect to via a application running on the host. However, I'm not able to connect to the database (I can connect to the database if I run the application inside the guest OS). Both operating systems are Windows XP 64. I'm using bridged networking mod...
Here's the story: I created a SQL Compact 3.5 database and used SQLMetal.exe to generate DataContext for it. It worked well, but soon I realized that it simply does not suit my needs so I decided to go for SQL Express 2008. I fired up the very same SQL script I used for the Compact to create schema and then fired up SQLMetal.exe tool. I ...
I just got a lovely access database, so the first thing I want to do is to move it over to a normal database management system (sqlexpress), but the only solutions I've found sounds like craziness. Isn't there a "export database to .sql" button somewhere? I have around 50 tables and this export might run more than once so it would be g...
i'm trying to set up some tables in my SQL Express server, and i want to do something to the effect of this: create table programs ( progid int primary key identity(1,1), name nvarchar(255), description nvarchar(500), iconFile nvarchar(255), installScript nvarchar(255) ) however i want each "program" to have a set ...
I am trying to write a local program management and install system for my home network, and i think i've got the technologies nailed down: C#/.NET/WPF for the client Lua for installation scripting support (through LuaInterface) SQL Server Express for maintaining a database of programs However i'm unsure what specifically i'll use to ...
I have a SQL2005 Express database that I would like to create a copy of on the same instance. How do you go about doing this with a script? I already have a script for generating the backup, but the restore is failing... THE ERROR: Msg 3234, Level 16, State 2, Line 2 Logical file 'MyDB_data' is not part of database 'MyDB_Test'...
Pretty much the same as this question. But I can't seem to get this to work with SQL Server Express in Visual Studio 2008. Same Table layout, One column with identity and primary key. ...
I have an SQL server on a server at home (which is an Atom processor with 1GB ram), and i'm using it to store data for one or two of my applications. I was wondering if i should create a DataContext object when the program starts then hold onto it for the entire life of the app, or only create the connection when necessary. What happens...
Hello, I already had the SQL Server 2008 Express engine installed (just the bit that comes with VS 2008 Express). I then installed SQL Server 2005 Express followed by SQL Server 2005 Management Studio Express, all of which seemed to install OK without any errors. However, when I run SQL Server 2005 Management Studio and enter the Serve...