I noticed that the SQL Express 2008 R2 does not list Windows XP as a supported operating system. While it seems to work fine, I'd need to be sure that everything is going to work on an XP machine should I deploy R2. http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135 Otherwi...
I need to inserd a record into sqlExpress thru javascript in aspx. Any Idea? ...
I'm trying to install SQL Server 2008 R2 Express from this site: http://www.microsoft.com/express/database/ I have a 64-bit, Windows 7 machine. I have tried both the 32-bit and 64-bit versions but each fail on "Performance counter registry hive consistency". How can I fix this so that I can install SQL Server 2008 R2 Express? ...
I'm trying to run my asp.net application on a windows machine (XP SP3, Vista, 7) which has only Microsoft.ACE.OLEDB.12.0 as the database engine installed and need to connect to the standard aspnetdb.mdf user database. Does any one know it is possible to use a connection string that works with mdf files in such a condition? I used connec...
I am using a SQL express databases as part of a unit test project in c#. My databases is located in ./Databases/MyUnitTestDB.mdf I would like to use a relative path or variable in the app.config rather than having my connection string defined as: .. AttachDbFilename=C:\blah\blah\blah\yea\yea\yea\MyApplication\Databases\MyUnitTestDB.md...
Hi, I have two .bak files These files contain different tables in them, and it is guaranteed that indexing is consistent across both files I can easily restore database A from A.bak and have tables a1, a2, a3 and likewise table B from B.bak with tables b1, b2, b3 What I really want is to restore database AB from both A.bak and B.bak ...
Possible Duplicate: Best practice to create (on demand) SQL Server 2008 Express databases in C#? In SQL Server Express (which is included with Visual Studio 2008), can I create a database dynamically at runtime? I mean create a database, not create a table. ...
I'm new to web development and am making a mini project on a simple social networking site. I'm using ASP.NET with C# & SQL Server 2008 Express. I've read articles on how one should aim to create a data access layer (DAL) for the database to be used. One method is to create strongly typed datasets & adapters via the designer tools prov...
Is it really to add Analysys Services for existing instance of SQL Server 2008 R2 Express? ...
Is it possible to use external activation on sql express without going thru sql enterprise/standard? I would like to send a message to sql express service broker, then have it notify my external application service running on the same box, in order to kick off a console app to pickup the message and process it. I do this already succes...
(MSSQL newbie alert) I have a number of databases on my machine, some were created using aspnet_regsql, others downloaded from the microsoft ASP.NET MVC 2 tutorials (e.g. http://www.asp.net/mvc/tutorials/mvc-music-store-part-3). The db's created with aspnet_regsql are listed in the wizard dropdown, but the ones I downloaded are not. I ...
Well, the subject heading essentially says it all: what's the difference between a SQL Server database file (.mdf) and an actual SQL Server database? Also, a couple of follow-up questions: Do database files exist for both SQL Server 2008 Express and SQL Server 2008 R2? Is there a difference between those if they do? When uploading a ...
Hi everyone, I have a basic/simple need to create a pipeline transfer process from one SQL express 2008 database to another server (equally SQL 2008 express). Basically: I have one table on SERVER A which has data coming in, and a default field called 'downloaded' which is again, by default set to 'N' I have the same table schema on ...
I don't have access to a SQL Server Express installation at the moment, but I know that the installer usually installs SQL Server Express with an instance name. What is the default instance name for SQL Server Express installations? I.e., how do you access such an installation by default? Is it localhost\SQLEXPRESS$ ? Is the same name us...
How to make my local SQL Server Express (which part of Visual Studio) available from outer network? ...
Recently upgraded to Windows 7 Enterprise 64 bit and Visual Studio 2010. In previous versions, we set up an alias to SQL Express 2008 to use localhost instead of .\SQLEXPRESS, so that our config files don't need to change when checking into TFS before being deployed to staging or wherever. After the upgrade, I can connect to SQL Expres...
Is there a way in SQL Server to create a table with a primary key that auto-increments itself? I've been looking at the "UniqueIdentifier" type, but this doesn't seem to do what I expect. Currently, I have something like this: CREATE TABLE [dbo].[MyTable]( [Date] [datetime] NOT NULL, [MyField1] [nchar](50) NOT NULL, [M...
I am upsizing the back end of a client's Access app tomorrow and need to be ready with a plan for a particular problem with this client. The boss needs to be able to take the data file away from the office where the SQL Server is on a regular basis (usually monthly) and run statistical analyses on the data. I've looked at Easiest way to...
Hello, I created install script that will install SQL Server 2008 R2 on windows XP SP3, windows vista and windows 7. One of the command that i used in the installation is for silent installation of SQL Server 2008 R2. When i install it on windows XP everything works just fine but when i try to install it on Windows 7 i get an error. ...
I am trying to uninstall SQLExpress (not quite sure what version) and am failing to do so. It shows up under "SQL Server 2005" in Add/Remove programs. When I click uninstall it says that it is scanning the configuration and then it closes down. Nothing happens. It still shows up in All Programs and Team Foundation Server (which I am ...