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

MSDE .BAK not compatible with SQL Server 2012?

I'm trying to copy a database from ye old MSDE to SQL Server 2012 Express, since Microsoft decided not to make MSDE compatible with Windows 7. Lo and behold, when I try the osql restore from disk command, I get the message that 8.0.2055 backups are…
user1480460
  • 11
  • 2
1
vote
1 answer

Error on compile or run the application on VS2010 & SQL Server 2012 Express

I'm getting an error when I try to compile or run the application. Performing a simple tutorial, I worked at first but now when I generate the project F6 or try to run it, I always get the error Error 1 Unable to…
rkmax
  • 17,633
  • 23
  • 91
  • 176
0
votes
0 answers

How Data type and memory usage works

If I will assign int data type for a column and assign 1 value then how much memory will be utilised How data type and memory utilisation works together
Ananda Sargar
  • 1
0
votes
1 answer

Column divided into sub columns in sql server

I have created a table like this with some data. DROP TABLE IF EXISTS #EmployeeDetail CREATE TABLE #EmployeeDetail(Name nvarchar(50),Department nvarchar(50),IsActive INT) INSERT INTO #EmployeeDetail(Name,Department,IsActive) VALUES (…
Y B
  • 85
  • 1
  • 1
  • 9
0
votes
0 answers

SQL Server 2012 table data export to excel file

I would like to export data from a SQL Server stored procedure to an Excel file. How can I achieve that? I test like that: insert into OPENROWSET( 'Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=D:\test.xlsx;;HDR=YES', 'SELECT EmpID FROM…
Loran
  • 772
  • 4
  • 16
  • 38
0
votes
1 answer

Error in DynamicDatabaseFactory.CreateDatabase connection string parsing

I'm not very familiar with DynamicDatabaseFactory and there isn't a lot of information out there. I'm making changes to a site and I'm just trying to get it to run on my development machine and I've run into this problem, the line:…
Prescott Chartier
  • 1,519
  • 3
  • 17
  • 34
0
votes
3 answers

I want to create a shared database c# windows form application?

This application that i am trying to create, whose "instances/copies" will be installed on multiple PCs of the client and are able to access the same database from another PC of the same client that has SQL server running all the time through the…
Alex Davidson
  • 21
  • 3
0
votes
2 answers

How to Target Last Month in SQL Query

I'm using this code in an SQL query WHERE [Date] >= DATEFROMPARTS(DATEPART(year,GETDATE()),DATEPART(month,GETDATE())-1,DATEPART(day,GETDATE())) AND [Date] <=…
Ronan
  • 23
  • 3
0
votes
1 answer

SQL Server backup from VB.NET not generating backup file, file not shown in drive

I am using VB.NET with SQL Server 2012 Express in a software. I provided facility to take a backup of a database from application itself with following code Dim con = New SqlConnection("Data Source=.\SQLEXPRESS;Database=Master;User…
Hemal
  • 3,682
  • 1
  • 23
  • 54
0
votes
0 answers

Exception while running crystal report on client machine

After installing C# windows application on my client's machine using click once deployment everything is working fine except Reports section where crystal report is being used. I am facing below exception as soon as the report tries to load :…
Shivangi Mittal
  • 19
  • 3
0
votes
1 answer

Auto Increment no

I want to auto-increment a serial number: "ATN/01-1920" WHERE ATN--given text,01-auto increment,1920--current financial The result should be like this: 'ATN/01-1920','ATN/02-1920','ATN/03-1920'..... Also, in a new financial year it should be reset…
Solomon Behera
  • 27
  • 6
0
votes
1 answer

Entity Framework 6 BulkInsert receiving an invalid column length from the client SQL SERVER 2012 Express

I have a little problem with Entity Framework 6. My application is a WPF C# application, I use SQL SERVER 2012 Express. I try to insert data into my Person table. It was working for a long time. Today I had an error : receiving an invalid column…
Coskun Ozogul
  • 2,389
  • 1
  • 20
  • 32
0
votes
1 answer

Char '00' not converting to int 01 from SQL Server in C#

I am fetching a column from database of char(2) data type. On an Event, I am changing the char data type to int and incrementing it by 1, with this code: int i = 0; using (SqlConnection sqlCon = new SqlConnection(Login.connectionString)) { …
Hafiz M Taha Waseem
  • 71
  • 2
  • 11
0
votes
2 answers

Connecting to SQL Database Server Remotely

I'll preface my question with: I am an absolute beginner with respects to the nature of MS SQL Server and have a layman's understanding of networking and 'computers' in general... So, I'm trying to replicate an environment where: There is an…
smashtest
  • 1
  • 1
0
votes
0 answers

SQL Server : tracking changes in recipe database

I have a recipe with about 30 values and need to keep a log of anytime the product is made using a recipe where any attribute is different than the last time the recipe was changed. Here is my sample code: if not exists (select 1 from --find…
JPoole
  • 305
  • 3
  • 13
1 2 3
…
26 27