I have a web application with a SQLExpress 2008R2 database in the AppData folder. I wanted to make an update to the database manually so in IIS I took the site offline. On the server I opened SQL Management Studio (as Administrator) and attached the database file and made my edits. I then detached the database dropping all connections...
Hi, I have the following query: WITH cte AS ( SELECT windowId, frameIndx, elemIndx, comment, ROW_NUMBER() OVER (PARTITION BY frameIndx ORDER BY elemIndx DESC) AS rn FROM dbo.translations WHERE windowId = 1 AND frameIndx IN ( SELECT indx FROM...
I have a class library that attaches itself a tiny SQL Server database that resides in its Data Directory. When i'm using this class library with another windows application i see that once i compile my code, the database files get copied to the bin folder of my windows app project. However when i publish the windows app,install, and run...
I would like access a sql express db in multiple projects, a dynamic data project to administrate the data and a console application which fetches the data from the db, is there an option to do this? or should I use a SQL CE for this kind of scenario? ...
I have a database program developed in Visual Studios 2005. It uses SQL Express in creating and connecting to the database. I have created a deployment package with SQL Express. Can this be installed on a PC that has SQL 2005 Compact Edition installed? ...
In our project (which is fully developed using .NET), we use a medium sized database about 2 GB in size. Currently we are using SQL Express edition; How do the alternates for SQL Server Express perform? I am mainly considering MySQL and PostgreSQL. (Windows 7 x86, x64) Is there any compelling advantage to using MySQL or PostgreSQL? W...
I am trying out Subsonic ActiveRecord to determine if I want to use it on any upcoming projects, and I gotta say I really like it so far. It worked great with MS SQL Server 2005 and 2008, but I am having problems with the T4 Templates and SQL Server Express. From what I can tell, Subsonic is having a problem getting the schema info from ...
Why do I get message that the table needs to dropped and re-created when I add/move columns? I believe this happens after adding foreign key constraints. What can I do to add new columns without dropping table? ...
I want to setup a website that uses an SQL Express .mdf file located in the APP_DATA folder. when I create the site as a file-system website, it connects to the database file without issue... however when I create the same site in IIS and I get to the point where it wants to attach to the SQL Express database, it says it cannot connect....
I am having 2 instances of SQL Server 2008R2 and instance of SQL Server Express 2008. SQLCMD, etc., works [1]. But "SQLCMD -L" and "OSQL -L" fail [2]. Why? What am I missing in SQLCMD use? How to use SQLCMD to get servers? [1] Test results of SQLCMD >sqlcmd 1> use AdventureWorks2008R2; 2> SELECT TOP(2) BusinessEntityID, FirstNa...
I added a new database to my project before (SQL Server Express database). And now i decide to set username and password to my database file. (*.mdf file i mean). How can i do this issue? Thanks in advance. ...
Despite using many sql databases before, I've never actually tried to develop an app with a database in the App_Data directory. Until now!! It's a small WCF service project, which has a sql express 2008 r2 database. Working in VS there are no problems, I thought it would be as easy as deploying to a server (win 2008 with sql 2008 r2 i...
Hello there, I came across these two services separately running in Services.msc - SQL Server (SQLEXPRESS) - started+Automatic SQL Server Agent (SQLEXPRESS) - Disabled Can you please guide why do we need SQL Server Agent (SQLEXPRESS)? Thank you! ...
Hello there, My machine Win7 has SQL Server 2005 and SQL Server 2008 installed. Also, Sql Server Management Studio is installed with SQL Server 2008. Now, I want to connect to SQLEXPRESS instance running currently on my machine. How do I know if i will need Management Studio 2005 or 2008 to connect to SQLEXPRESS? Just to add that I h...
Hi, I create a database in SQL Server 2008 Express (Advanced). Then i have a connection string in my C# using 'SharpDevelop' IDE, Version : 3.2.0.5777, .NET Version : 2.0.50727.3615 <add name="ConnectionString" connectionString='Data Source=.\SQLEXPRESS;AttachDbFilename="D:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS...
What I need to do is some data between 2 databases. The source can be anything (comma separated file, xls file, any database, ...), the destination is MS SQL Server. I do not need to sync all data, I just need to sync particular tables. Example: I need to sync accounting Software (runs on PostgreSQL) CUSTOMERS table with CRM (runs on ...