Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-express]

Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

The Microsoft® SQL Server® Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. Designed for easy deployment and rapid prototyping, this download includes support for Sysprep, Microsoft's System Preparation Utility for Microsoft Windows operating system deployment.

Source: Microsoft (SQL Server 2012 Express)

401 questions
0
votes
1 answer

Automate using SQL Express to export to Excel (not CSV)

I need to export about 20 different query results into one Excel file in seperate tabs. I know we can use SSIS pacakage but as I am using express addition it will not let me save it. As I will be running this checks every fortnight I am looking for…
Dhruvesh Shah
  • 121
  • 1
  • 1
  • 4
0
votes
1 answer

Can't access the SQL Server engine even from Management Studio

I just installed SQL Server 2012 Express edition on my computer (Windows 8). When I try to create a database from the Management studio, I'm getting the following error: Create failed for Database 'TestDB'. (Microsoft.SqlServer.Smo) CREATE…
Richard77
  • 20,343
  • 46
  • 150
  • 252
0
votes
1 answer

Best way to execute table compaction algorithm on SQL Server 2012 Express

Let me start by saying that I have limited SQL experience but I have searched for a few days to find a good solution to my problem and I haven't found it yet. If an obvious answer exists I haven't used the right key words to find it. I have a…
Jesse Ursery
  • 33
  • 5
0
votes
2 answers

ASP.NET - VB.NET - SQL Server Express 2012 - Storing dates

I'm trying to get the selected date from the Calender Control and store it to a column in the DB. I'm getting the following error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Date of Birth DB column:…
Brian
  • 1,951
  • 16
  • 56
  • 101
0
votes
1 answer

sql server 2012 Before the move

CODE : SELECT YEAR_ID, Count, ThreeYEARAverage, AVG(Count) OVER (ORDER BY YEAR_ID ROWS 4 PRECEDING) AS FiveYEARAverage FROM (SELECT YEAR_ID, ISNULL(Count, 0) AS Count, AVG(ISNULL(Count, 0)) OVER (ORDER BY YEAR_ID ROWS 2…
Park Ji Song
  • 13
  • 1
0
votes
0 answers

Can't create connections to SQL Server

I just installed VS2012 Ultimate in my new machine (Windows 7 Ultimate), now I found out that I can't add new connections to SQL Server, it says that .\sqlexpress was not found. It's as if the VS2012 installer didn't install the SQL Server Express a…
Rafael
  • 2,413
  • 4
  • 32
  • 54
0
votes
1 answer

SQL server cannot be connected

I am developing an Asp.net MVC4 application wherein i am using SimpleMemberShip provider for authorization and i am using database MSSQL Server 2012 on the same machine. When i openup the SQL server management studio and connect to the database by…
Yogesh
  • 3,044
  • 8
  • 33
  • 60
0
votes
1 answer

ASP.NET MVC 4 C# - Internet Application Template using default SimpleMembership, Error: System.Data.SqlClient.SqlException: Login failed for user xxx

I am running the application locally (localhost), and since I have already registered, I log in properly and then can navigate regularly through all the pages of my application. Then without logging out, I close the IIS express. But when I start…
Chris84
  • 101
  • 8
0
votes
3 answers

Referring to a table by variable

I'm sure this is pretty basic, but how do I set up an INSERT statement using a variable for the table name? For example, I have a number of input files, all configured identically (Input1, Input2, Input3, ...) all going to an INSERT or MERGE…
Deina Underhill
  • 557
  • 1
  • 9
  • 23
0
votes
0 answers

LINQ context refresh bug

I have LINQ to SQL classes and a DataGrid control. I set the DataSource of the DataGrid to context.Users and then I add user using context.Users.InsertOnSubmit(). However, DataGrid does not refresh itself, even after calling Refresh() explicitly.…
sczdavos
  • 2,035
  • 11
  • 37
  • 71
0
votes
1 answer

Unable to establish connection between SQL Server Express 2012 and Visual Studio 2012 Professional

Here is what I've done so far... I've downloaded SQL Server 2012 Express onto my machine- successfully restored the database that I'd like to access through VisualStudio 2012 Pro In VS2012Pro I've clicked on Add Connection in the Server Explorer,…
Working
  • 3
  • 3
0
votes
2 answers

SQL Server mdf file cannot be connected by both ASP.NET application and SQL Server Management Studio

I have a simple ASP.NET website application. Using the new Entity Framework model-first approach, I created a database (.mdf file). However, whenever the application is running, SSMS cannot connect to the database (error 5123 or 5120), and vice…
delta2006
  • 425
  • 2
  • 4
  • 13
0
votes
0 answers

Connect (Bind) database to WPF application

I have created a front end application in WPF (VS2012) and I have to connect a database to it. Do not know how to connect SQL database with WPF application. Kindly guide me Thanks in advance!
mshahbazm
  • 611
  • 1
  • 11
  • 23
0
votes
1 answer

Import a text file by converting repeating groups of lines into columns

My data file looks like 1234567 7654321 TEXT ABOUT STUFF ON MULTIPLE LINES NOT SURE HOW MANY 1234567 7654321 TEXT ABOUT STUFF ON MULTIPLE LINES NOT SURE HOW MANY The only thing for certain is a new record starts with 2 sets of numbers that are 7…
Cocoa Dev
  • 9,361
  • 31
  • 109
  • 177
0
votes
0 answers

Is SQL Server 2012 express faster than SQL Server 2005 Express?

Recently, I upgraded my development computer to Windows 8 and now, I am having hard time installing SQL Server 2005 express on my development machine. My ASP.NET MVC Website project is based on SQL Server 2005 Express. (Entity Framework CodeFirst…
Emran Hussain
  • 11,551
  • 5
  • 41
  • 48
1 2 3
…
26 27