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

Many to Many and Composite Primary Key and Foreign Key

I am building a system where there are properties and prospects, I have a table for both, but as I see this as a many to many relationship, I have created a table called prospect_property with two columns prospect_id and property_id, these are…
Jesper
  • 999
  • 3
  • 14
  • 30
0
votes
1 answer

asp.net getting error when trying to get or set profile properties

I'm having trouble figuring out why I'm getting this error message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance…
DerpyNerd
  • 4,743
  • 7
  • 41
  • 92
0
votes
1 answer

TSQL Maxrecursion on a cte

I get this error: The maximum recursion 100 has been exhausted before statement completion when I run this function: WITH allDays AS ( SELECT @DateEarly AS date UNION ALL SELECT DATEADD(dd, 1, date) as date …
Tobia
  • 9,165
  • 28
  • 114
  • 219
0
votes
1 answer

Problems configuring a user for a SQL Server Express 2012 ODBC DSN

Good morning everyone!!! I'm having a problem configuring an ODBC DSN for SQL Server Express 2012 to be used in a Scada program. For this I made a DB and I created a new user and password with the queries used in the first reply of the following…
Marialvy Martínez
  • 286
  • 2
  • 6
  • 19
0
votes
2 answers

SQL Query: last, second last, third last..value (Microsoft SQL)

I am trying to build reports for sport team. The results are stored in a SQL-Database like this: For the reports I need the columns Home2-Away4 to be filled with the corresponding results. Which means: Imagine: ID=10 and Home(no.) (Team#) = 1 -->…
Stefan Hubert
  • 35
  • 1
  • 7
0
votes
3 answers

MySQL query not runnable in SQL Server Express

I am using Microsoft SQL Server 2012 Express. The following code from MySQL gives me error when running query, can anyone guide me in how to correct it? /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET…
user1487718
0
votes
3 answers

Connecting to a SQL Server database

I installed Visual Studio 2010 and SQL Server Express 2012. Then I created a new database in SQL Server Management Studio. Can someone tell me how to connect to this database from Visual Studio (the type of project is not relevant) and start…
Amer A.
  • 1,025
  • 2
  • 16
  • 22
0
votes
1 answer

How do you use Crystal Reports 2011 with Sql Server Express 2012?

I am trying to find out how to use crystal reports with sql server. I know in .net there is an "engine" that you can use to run a crystal report, but what if I just want to use sql server and CR? Is there a way to load the CR .rpt into Sql Server…
johnny
  • 19,272
  • 52
  • 157
  • 259
0
votes
1 answer

What Database to use for a network share?

I need help picking a database to use for an application I am writing. Basically I am writing an application that will have about 5-10 users accessing the database to input values, generate reports, or simply to look up information. We are currently…
twreid
  • 1,453
  • 2
  • 22
  • 42
0
votes
0 answers

SQL Server 2012 Express redundant processes

I have been having some odd issues recently during the development of a new web app. So I decided to have a look at SQL Server as a possible source of random hangs etc. On looking at the Activity monitor in SQL Server Management Studio, I see that…
Digital Lightcraft
  • 455
  • 1
  • 7
  • 31
0
votes
2 answers

Accessing windows registry in C#

I am trying to get all the SQL Instances installed on a local machine with the help of following code: RegistryKey rk = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server"); string[] instances =…
Muhammad Ali
  • 139
  • 1
  • 1
  • 6
0
votes
2 answers

Database connection failed SQL Server 2012 Express + node.js

I'm getting the "Database connection failed" trying with the Node.JS driver for SQL and the example from: http://blogs.msdn.com/b/sqlphp/archive/2012/06/08/introducing-the-microsoft-driver-for-node-js-for-sql-server.aspx The string I use against…
NikG
  • 195
  • 1
  • 2
  • 10
0
votes
2 answers

How can I get the Design mode of a table without going through "Object explorer"?

I'm trying to use SQL Server Management Studio to edit database tables. But I can't seem to access the databases themselves through "Object explorer" (SQL Server Management Studio 2012 hangs). How can I get the Design mode of a table without going…
ispiro
  • 26,556
  • 38
  • 136
  • 291
0
votes
2 answers

Moving from SQL Server 2008 to SQL Server 2012 Express

I am moving an app from SQL Server 2008 to SQL Server 2012 Express, and all is well but several stored procedures are saying I have a syntax error. I have looked online and have not found an answer - are there types of syntax that are supported in…
zortacon
  • 617
  • 5
  • 15
-1
votes
1 answer

Object of class DateTime error when i export data to excel

I have a table which contain many columns. Some column contain numerical value, some contain text while some contain date. When i try to export data to Excel, the numerical and value can be exported however when i want to export date data, it shows…
Honestman
  • 177
  • 1
  • 1
  • 12
1 2 3
…
26 27