Stack Overflow
Stack Overflow

Questions tagged [sql-server-express]

Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system. It is targeted for embedded and smaller-scale applications, having a number of technical restrictions.

1718 questions
0
votes
7 answers

Recommended SQL database for commerical product

We have a commercial off the shelf product which used a Access Database. Due to the limitations and corruptions involved in multi user environments we decided to move to SQL Express. However now asit turns our,deployment of SQL Express 2005/2008 is…
superartsy
  • 489
  • 1
  • 11
  • 27
0
votes
0 answers

How to Create a Database for Multiple User Access on a Central Drive

For my sins I have become the Excel Whiz for my department (believe me, in my department, just being able to open Excel puts you ahead of the pack!). I created them a spread sheet for developing their annual budget. This worked well but now they…
Steve
  • 1
  • 2
0
votes
1 answer

lost my ASPNETDB.mdf

I am working on the MVC storefront Rob Conery project and I lost my ASPNET.mdf database ! I would like to have the ASPNET.mdf database in my App_Data folder. I tried to include the db right clicking on it and including it in the project. But on the…
Bernard Larouche
  • 1,211
  • 2
  • 13
  • 22
0
votes
3 answers

Select * into SqlserverTable2 from SqlExpressTable1, can this be done

Can I Select * into a Sqlserver Table from a SqlExpress Table the way I can from a Sqlserver Table to a Sqlserver Table using Select * into Table2 from Table1 If so, what is the syntax?
Lill Lansey
  • 4,775
  • 13
  • 55
  • 77
0
votes
1 answer

Can .mdf use as embedded database?

I am new to C# and SQL Server databases, so this may be a stupid question but I am confused. I want to setup an embedded database on a client machine automatically when he installs my application. I know SQL Server Compact Edition is there but there…
user3149221
  • 5
  • 4
0
votes
2 answers

How to access SQL Server 2012 Express remotely

I am using SQL Server 2012 Express and I have enabled remote connections plus also have followed the steps give in the LINK However I am unable to access the server remotely and what server name should be specified the public ip address?
vini
  • 4,657
  • 24
  • 82
  • 170
0
votes
0 answers

Can I package SQL Server Express with my Visual Studio program deployment?

I have created an application in Visual Studio that uses a .mdf database and executes SQL scripts on it. The program imports and exports reports to and from Excel. I want to be able to give this program to team members, but they get an error "error:…
bheltzel
  • 131
  • 1
  • 2
  • 10
0
votes
2 answers

How to read and compare data from an SQL Server Express database

I am trying to create a select statement in C# to check if the value inserted into a textbox (userName) is in an existing SQL database. I have a database called Employee containing a table called EVUSERS and it has a column called UName. In my code…
user3008146
0
votes
1 answer

How to use Triggers in SQL Server 2012 to archive and delete

I will be honest, I know nothing about SQL Server other than what I have tried to pack into my brain in the last two days.... I have found a couple of scripts on your website that sounded like they would work What are ways to move data older than…
user3155025
  • 1
  • 1
0
votes
4 answers

What services are required by SQL Express/SQL Server?

One of our partners recently reported that our software could not contact a remote instance of SQL Express until they started the RPC Locator and SQL Server Browser services. Where would I find a list of services that must be running, on both server…
dgvid
  • 26,293
  • 5
  • 40
  • 57
0
votes
0 answers

Connection string from Visual WebDeveloper to SQL Server Express database for login screen

I'm trying to create a simple login screen using Visual WebDeveloper aspx page and SQL Server Express. My SQL Server name is SPAZZ\SQLEXPRESS. I have a database called H2H and a table inside the database called tblUserUser. Inside the tblUserUser…
Nikki
  • 85
  • 16
0
votes
2 answers

Filling the grid View with more than 1 table?

I have the following code SqlConnection con = new SqlConnection(); con.ConnectionString=@"Data Source=RITESH-PC\SQLEXPRESS;database=master;Integrated Security=true"; con.Open(); SqlDataAdapter adp = new SqlDataAdapter("Select * from…
user3134022
  • 1
  • 1
0
votes
1 answer

How to set system admin password for SQL Server Express

I understand this should be searched online. I did but most of the links point to SSMS and UI for doing this. I am relying on Visual Studio 2012 SSDT and self-typed SQL query. Please help me with below SQL command to set sa password. CREATE LOGIN…
Abhijeet
  • 13,562
  • 26
  • 94
  • 175
0
votes
1 answer

SQLExpress database instance not commiting changes with local mdf db

I'm building my application using .NET. I created a SQLExpress database instance using Visual Studio and connected to it using LINQ. This is its connection string Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TicTacToeDB.mdf;Integrated…
Ibrahim.I
  • 229
  • 1
  • 4
  • 18
0
votes
1 answer

Can't attach database to SQL Server Enterprise, needs Express?

I already have SQL Server Enterprise 2012 on my PC and the service that is running is MSSSQLSERVER (found on SQL Server Configuration manager). I am trying to attach a database which requires SQL Server Express! I downloaded SQLEXPR_x64_ENU and…
user3077814
  • 1
  • 1
  • 2
1 2 3
…
99
100