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

How to generate a configuration file for SQL Server 2012 Express?

I want to generate a configuration file for SQL Server 2012 Express, I found Microsoft answer here: Install SQL Server 2012 Using a Configuration File But there is no Ready to Install page! Please help me to accomplish that. Thanks in advance
Abdulsalam Elsharif
  • 4,773
  • 7
  • 32
  • 66
1
vote
1 answer

RDLC report in Windows Forms using Visual Studio 2012

Development Environment: Visual Studio 2012 Professional, RDLC, Windows Forms, SQL Server 2012, Entity Framework 5.0 I am working with RDLC in Windows Forms using Visual Studio 2012, I am facing issue of not populating my RDLC report in Windows…
Anjan Kant
  • 4,090
  • 41
  • 39
1
vote
2 answers

SQL issue with CASE statement

I'm trying to adjust the following statement: SELECT CASE WHEN OrganizationLevel < 2 THEN UPPER(JobTitle) ELSE JobTitle END as 'Job Title', COUNT(BusinessEntityID) as 'number of employees' FROM HumanResources.Employee …
Xid Stargazer
  • 13
  • 2
1
vote
2 answers

How to enable SQL Server Agent in SQL Server 2012 Express

When I try to start SQL Server Agent from SQL Server Configuration Manager I get this error the request failed or the service did not respond in a timely fashion.Consult the error log or other applicable error log for details So how can I solve…
Abdullah Al Mamun
  • 351
  • 3
  • 4
  • 15
1
vote
1 answer

When I install SQL Server 2012 Express I do not see the SQL Server Management Studio

When I install SQL Server 2012 Express I do not see the SQL Server Management Studio when I look for it via Start -> All Programs -> SQL Server 2012 Express.
Hermes1160
  • 31
  • 2
1
vote
1 answer

Unable to connect to SQL Server in Hydro GeoAnalyst

I have installed Hydro GeoAnalyst 2014.2 and i have started trial and wanted to install demo project. Firstly, i must select data source type, available server and database name. I select data soruce type, then i write sql server instance name and…
rockenpeace
  • 1,011
  • 5
  • 18
  • 29
1
vote
1 answer

change a query to an update

I have the following query: SELECT UsersAccountLink.UserId, Customer.Account.AccountNumber, Web.Customer.Name, Web.Customer.Street, UsersAccountLink.AccountId FROM UsersAccountLink INNER JOIN Web.Customer…
ErocM
  • 4,505
  • 24
  • 94
  • 161
1
vote
1 answer

SQL Function returns no results, but function content returns results

I have the following SQL function definition and test: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[udf_Assessment_Timelines]') AND type IN ( N'FN', N'IF', N'TF', N'FS', N'FT' )) DROP…
hofnarwillie
  • 3,563
  • 10
  • 49
  • 73
1
vote
4 answers

Remote SQL Server connection string

I have had a project where SQL Server and development all worked locally. The following connection string was used: SqlConnection connection= new SqlConnection("Data Source=.\\MYDB;Initial Catalog=Database;Integrated Security=true"); …
RenegadeAndy
  • 5,440
  • 18
  • 70
  • 130
1
vote
1 answer

How to get Object Schema using TSQL

Aside from sp_help 'mytablename' which gives a break of each element of an object, is there a way getting the raw SQL. Just the same as doing the following in Microsoft SQL Server. Using sp_helptext 'mytablename' says the following; There is no…
wonea
  • 4,783
  • 17
  • 86
  • 139
1
vote
0 answers

I can't find msmdpump.dll

I installed SQL Server 2012 Express Edition 64 bit on Windows 7 64 bit. Installation completed successfully. But when I try to configure HTTP Access to Analysis Services on Internet Information Services (IIS), I am not able to find MSMDPUMP.dll file…
Pankaj Shinde
  • 3,361
  • 2
  • 35
  • 44
1
vote
1 answer

check values of column in sql

I am trying to collect values from a database, and if they are X value sett he background colour to green. Basically, I have a Rota system, and if the user is working, then change the background colour. The select * will only bring back 1 row ever.…
JoeM
  • 93
  • 1
  • 3
  • 13
1
vote
2 answers

"service broker" The server principal "sa" is not able to access the database under the current security context

I'm working with SQL Server 2012 Express. I'm using Service Broker to run a stored procedure asynchronously. The activation procedure has to access another database to execute another stored procedure. This is the code: CREATE PROCEDURE…
VansFannel
  • 45,055
  • 107
  • 359
  • 626
1
vote
2 answers

how to create SQL Server Database with vb.net code

I'm using VB 2012 and SQL Server 2012 Localdb I want to create a database file (.mdf) in my folder C:\AppData eg. db file name 0105.mdf & log file name 0105.ldf Can anyone please tell me the procedure? I can connect to SQL Server 2012 localdb using…
Amit Saraf
  • 101
  • 1
  • 3
  • 15
1
vote
0 answers

Restore a SQL Server 2008 database to SQL Server 2012 Express

When I try to restore my .bak file, a SQL Server 2008 database file from my production server, to my local SQL Server 2012 Express server, I get the following screenshot: Where I see No backupset selected to be restored and an empty dropdown under…
Adam
  • 6,041
  • 36
  • 120
  • 208
1 2 3
…
26 27