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
0 answers

Microsoft SQL Server 2012 Express - Importing encrypted database

I have a file of database that I want to import into my SQL Server 2012 Express. I tried importing options but I always get undefined file. click run to see the image
0
votes
1 answer

Unknown web method Delete_Local_ABC. Parameter name: methodName in ASP.NET app

I have been getting this error on my following code, which basically initiates the POST request as ABC.ascx var ABCid = $(aTag).data('id'); $.ajax({ type: "POST", url: "WebMethods.aspx/Delete_Local_ABC", …
Ahmed S. Durrani
  • 1,535
  • 2
  • 17
  • 41
0
votes
1 answer

Loop through a table without using a cursor or temp table finding records over 30 days old

Using SQL Server 2012. I need to loop through my table without using a cursor or a temp table. Also, I know the debate re: cursors... :) AND I have script at the bottom of this question using sys.databases and msdb.dbo.restorehistory getting the…
Mintz
  • 1
  • 3
0
votes
0 answers

Django 1.11 Unable to Connect SQL Server Express 2012 with django-pyodbc-azure

FYI, I am just getting back into programming after not coding for a few years. My programming lingo might be off; so, I hope this does not off-put anyone in the community Technologies I am using for this issue: Windows 7 Pro 64-bit Python…
0
votes
1 answer

How to assign value to Lastrow and Firstrow parameter using some variable in BULK INSERT?

DECLARE @sqlCommand VARCHAR(MAX) DECLARE @NAME varchar (100) DECLARE @FIRSTROW INT,@LASTROW INT SET @FIRSTROW = (SELECT TOP 1 [Id] FROM [dbo].[TableB] ORDER BY [Id] DESC) + 1 SET @LASTROW = @FIRSTROW + 4 SELECT @NAME = (SELECT…
0
votes
1 answer

How to check if SQL Server 2012 Express edition is installed or not in wix toolset?

How to check if SQL Server 2012 Express edition is installed or not in Wix toolset installation?
Prashant Kumar
  • 239
  • 1
  • 6
  • 15
0
votes
1 answer

I faced an error while logging in to my SQL Server 2012 Express

The error: A connection was successfully established with the server,but then an error occured during the login process(provider:SSL Provider:0-The specified data could not be decrypted.) (Microsoft SQL Server0
Hassan Tariq
  • 730
  • 7
  • 15
0
votes
0 answers

View a specific report on browser without prompt to log in

I have set up a 2012 R2 MSSQL Server 2012 R2 Express with a Report Server. I would like to be able to view a report from any computer on any network without the need to log in. I went into the SQL Server Reporting Services…
0
votes
1 answer

Construct a grouping column in SQL Server 2012

I have created a table that looks something like this: ID TSPPLY_DT NEXT_DT DAYS_BTWN TIME_TO_EVENT CENSORED ENDPOINT ----------------------------------------------------------------------------- 1 2014-01-01 2014-01-10 10 …
Brrrr
  • 59
  • 5
0
votes
1 answer

Unable to connect Android App to local MSSQL database

Hi I created a SQL management Database, I wish to connect to the Database through Android App I am not what I did wrong, I am not able to login. This my SQL management Studio 2012, My DataBase name I call it DB. This is my SQL Server Configuration…
user2399158
  • 561
  • 3
  • 10
  • 26
0
votes
2 answers

Deploying Linq-to-SQL C# application that contains service based database

I built a C# application in Visual Studio with Linq-to-SQL and it contains a service-based database (.mdf file). I want to deploy it to another computer so it can be used there. I have already created the setup installer using Visual Studio…
0
votes
1 answer

Transaction count after EXECUTE a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0

Create Proc A as begin Begin try --Logic Here Execute B end try begin catch end catch End Above is my two sp's I am calling SP B from SP A. there are two different databases present in…
0
votes
1 answer

sqlsrv_has_rows() ERROR PHP with MSSQL

I'm having a slight problem with my php page which I just don't understand. I'm new in this and i don't really understand my query. When i try to execute my program, error appear like this Warning: sqlsrv_has_rows() expects parameter 1 to be…
Damuslo
  • 31
  • 6
0
votes
1 answer

Cannot find SQL server 2012 configuration tools

I upgraded my OS from MS windows 8.1 to 10. Now I cannot connect to the server with my working databases and I cannot find the configuration tools to start the server again.
Cliff Crerar
  • 433
  • 8
  • 24
0
votes
1 answer

DNN 8 Installation

I have been trying to setup a dev. environment of DNN8 on my system. On installation wizard page, its keep giving DB connection error mentioned below. Database Information: Unable to connect to database. Database Connection Error ERROR: Index #:…