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
12
votes
2 answers

Getting error "commandtext property has not been initialized" when sql compare of Red Gate

When I compare the 2 databases with the Red Gate's SQL compare then getting below error. "ExecuteReader: CommandText property has not been initialized" I am using the SQL server 2012 express and Red Gate's SQL Compare 8 Is there any…
Tushar Maru
  • 3,347
  • 10
  • 34
  • 53
11
votes
6 answers

How to fix Visual Studio's error "This server version is not supported..." for SQL Server 2012

I recently installed Visual Studio 2010 and SQL Server 2012 on a Windows Server 2008 R2 machine - (including all updates/Service Packs). When attempting to work on a SQL Server database from within Visual Studio, VS throws the following error: This…
Jed
  • 10,649
  • 19
  • 81
  • 125
9
votes
7 answers

Keep getting "Login failed for user IIS APPPOOL\DefaultAppPool" no matter what I do

I'm trying to give an ASP NET App access to a database (These are test only not production). It's the first time I try it in this network, and I haven't done it with VS2012, SQL Server 2012 Express, Windows 7 before What I have done: I upgraded my…
Rafael
  • 2,413
  • 4
  • 32
  • 54
9
votes
2 answers

Can't create stored procedure with table output parameter

I have this code: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetProfitDeals]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[GetProfitDealsVar2] GO IF EXISTS(SELECT 1 FROM sys.types WHERE name = 'TableOrderType'…
Relrin
  • 760
  • 2
  • 10
  • 28
9
votes
0 answers

Creating connection to MDF-file in Visual Studio: "File is in use"

Introduction I'm new to the Entity Framework and setting up a correct SQL Server. I'm following the official Entity Framework tutorial and I'm at the "Creating the Database"-step about 30% down the page. Steps to reproduce the problem copy the…
Aske B.
  • 6,419
  • 8
  • 35
  • 62
8
votes
1 answer

SQL Server 2012 Express backup database failure

I am trying to backup a database I have created in SQL Server 2012 Express. I right click the database -> tasks -> backup and assume normal defaults. The error I get is then this: TITLE: Microsoft SQL Server Management…
RenegadeAndy
  • 5,440
  • 18
  • 70
  • 130
8
votes
1 answer

Hiding databases for a login on Microsoft Sql Server 2008R2 and above

Please can anyone assist with hiding the available databases on sql server 2008R2 or newer versions. I have a new login user that I mapped to a specific database. When logging in with the specific login user I can see all the databases on the…
Omgee Cares
  • 427
  • 2
  • 5
  • 12
7
votes
4 answers

List all working dates between two dates in SQL

i have the SQL code to generate the date list between two dates, but i want to generate the week days (Business days) from the given two dates, DECLARE @MinDate DATE = '20140101', @MaxDate DATE = '20140106'; SELECT TOP (DATEDIFF(DAY, @MinDate,…
user1799596
  • 117
  • 1
  • 8
7
votes
3 answers

SQL Query Date search using Between

I just run this query Select * from ProjectData where logtime between '2012-09-25 12:00:00.000' and '2012-09-25 12:59:59.999' order by LogTime in an attempt to find the all record for 12 hour, We have record every second, so I was expecting…
Sumit Gupta
  • 2,152
  • 4
  • 29
  • 46
7
votes
2 answers

Odd SQL Server 2012 IDENTITY issue

I've never seen this happen before, very odd. I have a local SQL Server 2012 Express database that I'm developing against. Running a simple suite of tests using the TestDrive plugin and accessing the database with EF v5. I just ran a test that…
Jammer
  • 9,969
  • 11
  • 68
  • 115
6
votes
1 answer

How to add oracle data source in ssrs

I've installed SQL Server 2012, after I've installed all features including report services. I go to Report Manager link and wanted to add New Data Source, but in Data Source Types there is only Microsoft SQL Server and I want to add Oracle Data…
user3131955
  • 93
  • 1
  • 1
  • 4
6
votes
3 answers

How to view query that was used to create a table?

I create about 15 tables and create relationships and constraints among them using Wizard in SQL Server 2012 express Now i want to see the query that is used to create those tables including relationships and constraints. Can u provide help? Thank…
Topman
  • 306
  • 1
  • 4
  • 14
6
votes
6 answers

Classpath set, but: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Okay, I'm confused. My SQL Server JAR is here: Volume in drive C has no label. Volume Serial Number is 8008-2D93 Directory of c:\temp 03/07/2014 09:38 AM . 03/07/2014 09:38 AM .. 03/05/2014 10:34 PM …
Doug
  • 6,446
  • 9
  • 74
  • 107
6
votes
3 answers

Looking for a not-deprecated session-factory

I am dealing with hibernate and as I opened my current project I figured out my Session-Factory is deprecated: AnnotationConfiguration af = new AnnotationConfiguration(); SessionFactory factory = af.configure().buildSessionFactory(); Session session…
Qohelet
  • 1,459
  • 4
  • 24
  • 41
5
votes
3 answers

A connection cannot be made. Ensure that the server is running

When I am trying to process dimensions after creating a data source view I get the error: The project could not be deployed to the server because of the following connectivity problems : A connection cannot be made. Ensure that the server is…
mnv
  • 53
  • 1
  • 1
  • 6
1
2
3
…
26 27