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
1
vote
1 answer

ColdFusion 10 Administrator, MS SQL 2012 and Windows 8

I've been trying to add a datasource in the ColdFusion Administrator for Windows 8 and I've been having many issues. Below is what I've done: Database created "onessBlog". Login created onessBlog with password onessBlog / SQL Server Authentication…
Chester
  • 1,081
  • 9
  • 18
1
vote
2 answers

Trouble installing SQL Server 2012 Express with Advanced Services

Whenever I try to install SQL Server 2012 Express with Advanced Services I am getting this error: I have tried both version (32-bit/64-bit) and re-downloaded multiple times. How can I solve it ?
Brian
  • 1,951
  • 16
  • 56
  • 101
1
vote
1 answer

VS2012 and SQL Server Express

I learnt that VS2012 comes with a version of SQL Server Express named LocalDb that works a little bit different from the usual SQL Server Express, the latter one works as a service. What if I was interested in using the database as a service, can I…
Rafael
  • 2,413
  • 4
  • 32
  • 54
1
vote
2 answers

What is the meaning of 'LocalDb'?

I learned is that in order to connect to SQL Server Express 2012 I have to use the instance name "(LocalDb)\v11.0". Is this localDb a special db for local developmnents or is it the exact equivalent to Sql Express 2008 but with a different name?
Rafael
  • 2,413
  • 4
  • 32
  • 54
1
vote
2 answers

Import Excel 2010 into SQL Server

I use Excel to collect & configure data, then import it into SQL Server 2012 for storage. So far I've been using the SQL Server Import & Export Wizard, but it is a pain to manually set it up constantly. Since I'm using Express, of course it won't…
Deina Underhill
  • 557
  • 1
  • 9
  • 23
1
vote
2 answers

MERGE keeps trying to insert null

When I run this, I keep getting: Msg 515, Level 16, State 2, Line 8 Cannot insert the value NULL into column 'uNSID', table 'Flickr.dbo.User_Grps'; column does not allow nulls. UPDATE fails. The statement has been terminated. This is my SQL…
Deina Underhill
  • 557
  • 1
  • 9
  • 23
1
vote
1 answer

Conditional Joins to intermediate file MS Server 2012 Exp

My database has 3 tables: [Groups] - information on specific groups, CREATE TABLE [dbo].[Groups]( [Prime_ID] [nvarchar](20) NULL, [Name] [nvarchar](100) NULL, -- there are a number of other fields as well ) ON [PRIMARY] [User_Groups] - not…
Deina Underhill
  • 557
  • 1
  • 9
  • 23
1
vote
4 answers

Is there a way to generate a ~million mac addresses more efficiently?

Is there a way to generate a ~million MAC addresses more efficiently? Here is what I am doing, however it is taking ~10 minutes to generate a million MAC addresses and insert them into my table: DECLARE @StartRange BINARY(6) DECLARE @EndRange…
Mausimo
  • 8,018
  • 12
  • 52
  • 70
1
vote
1 answer

Remote connection to SQL Server 2012 Express

To clarify this in the start. I don't have much experience with SQL Server so every help will be appreciated. I have a task to set up some program with a SQL Server Express database which is located on a remote server. The database is, as far as I…
Amer A.
  • 1,025
  • 2
  • 16
  • 22
1
vote
0 answers

Visual Studio 2012 + SQL Server 2012 Express table deleted

I have a big problem. I am running Visual Studio 2012 and SQL Server 2012 Express. I made a connection in VS to the SQL Server successfully, and then proceeded to create a table. I create the table and click the Update button. Now, in the Server…
user1830833
  • 151
  • 1
  • 2
  • 10
1
vote
1 answer

Error when installing SQL Server 2012 Express

When I attempt to install SQL Server 2012 Express, I get an error However, I have installed service pack 1. BTW, I am using windows 7. Could someone help me?
user1487718
1
vote
2 answers

Enable power view in SQL Server 2012

i have installed SQL Server 2012 in my system, now i want to enable power view for reporting services. i don't know how to do this. can you tell me steps by step installation procedure...?
Harry
  • 51
  • 1
  • 5
1
vote
0 answers

Is it impossible to view and edit T-Sql statements from within Visual Studio 2012?

I am thinking of migrating our database from SQL Server to SQL Azure, but I am a little concerned about the problems with the tooling I've been having. Specifically, I haven't been able to "design" a T-SQL query directly from VS while working with…
Trex
  • 145
  • 1
  • 13
1
vote
4 answers

SQL Server 2012 Express connection error

I installed SQL Server 2012 but not able to connection to express instance getting below error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.…
Vipul
  • 1,563
  • 4
  • 22
  • 46
1
vote
1 answer

Can't attach the sample database in SQL Server 2012

I have downloaded the sample database for SQL Server 2012 Express but I am having the following error message whenever I try to attach it: The database 'AdventureWorks2012' cannot be opened because it is version 706. This server supports version…
darking050
  • 617
  • 1
  • 7
  • 20
1 2 3
…
26 27