sql-server-express Questions
7
I am working on asp.net c# project, for connection I used:
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\19-02\ABCC\App_Data\abcc.mdf;Integrated Security=Tru...
Passover asked 1/3, 2014 at 11:27
3
I'm failing to connect to a SQL server SQLExpress. The connection worked fine a few days ago.
This is how I tried to connect (I'm using Microsoft SQL server management studio):
connection = pyodbc...
Metallo asked 6/5, 2016 at 11:53
10
Solved
I am trying to write a local program management and install system for my home network, and I think I've got the technologies nailed down:
C#/.NET/WPF for the client
Lua for installation scriptin...
Patsy asked 28/8, 2009 at 7:18
2
I try to add the "mdf" database file to the project, I get an error.
How to fix the error?
Error:
The attempt to connect to the database
failed; the following information was received:
Lo...
Lupulin asked 23/3, 2022 at 5:37
3
Solved
I have a Dockerfile with below code
FROM microsoft/mssql-server-windows-express
COPY ./create-db.sql .
ENV ACCEPT_EULA=Y
ENV sa_password=##$wo0RD!
CMD sqlcmd -i create-db.sql
and I can create im...
Dropsy asked 26/6, 2018 at 20:2
17
I am having an issue with Azure Storage Emulator. I tried to re-initialise the database and got the error below.
This was after installing Visual Studio 2019 Preview but this may just be a co-inc...
Kanaka asked 7/12, 2018 at 16:51
9
Solved
I have a database in a local file that is used by a program. The program has limited functionality and I needed to run some quick queries. I installed SQL Server Management Studio Express 2005 (SSM...
Ansilme asked 16/12, 2011 at 1:21
21
Solved
I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this w...
Gunmaker asked 26/9, 2008 at 18:32
6
Solved
Why do I get message that the table needs to dropped and re-created when I add/move columns?
I believe this happens after adding foreign key constraints.
What can I do to add new columns without d...
Rema asked 9/10, 2010 at 9:14
5
All previous version of SQL Server Express were available in both web and full downloads. But I cannot find full download of SQL Server® 2016 Express. Does it exist?
Asked the same question on MSD...
Duet asked 3/10, 2016 at 16:14
11
Setup: Entity framework code first to new database.
Scenario: I'm playing around with EF and I add a bunch of elements to my database. I then change the entity model, and while I know that I could...
Light asked 10/3, 2013 at 4:15
16
This is the query I'm using:
DELETE TB1.*, TB2.*
FROM TB1
INNER JOIN TB2 ON TB1.PersonID = TB2.PersonID
WHERE (TB1.PersonID)='2'
It's working fine in MS Access but getting error (Incorrect ...
Narbonne asked 11/11, 2009 at 11:18
27
Solved
I have a database file .mdf from MS SQL EXPRESS in folder:
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA
I would like to attach it to MS 2008 R2 (MSSQL10_50.MSSQLSERVER) bu...
Ludwog asked 24/6, 2012 at 15:7
6
Solved
When printing a report, the user sometime have the following error:
CrystalDecisions.CrystalReports.Engine.LogOnException:
Error in File C:\DOCUME~1\carolec\LOCALS~1\Temp\temp_b117cc2e-c184-4556-...
Vibraharp asked 6/7, 2009 at 14:59
2
Solved
I am very intrigued by this new version of SQL Server Express.
It's not clear (to me) what a setup program should do to deploy an application that use a LocalDB.
Is it required to install SQL S...
Avenue asked 11/3, 2012 at 13:32
12
Solved
I'm trying to connect to an MDF. I've even gone to the lengths of re-installing sql server express entirely (it is now the only flavor of SQL installed on my box, where previously I had 05 dev and ...
Letta asked 11/11, 2008 at 17:7
2
Solved
I'm trying to install Microsoft SQL Server 2019 Express but I keep running into the above error message.
I was originally running into a separate error message when trying to install that said
A r...
Theresiatheresina asked 19/4, 2022 at 13:20
10
I have a problem with this trigger. I would like it to update the requested information
only to the row in question (the one I just updated) and not the entire table.
CREATE TRIGGER [dbo].[after_...
National asked 29/8, 2014 at 12:41
6
I've attempted to add a "service based data base" (.mdf) to a project in an asp .net application. From there I've proceeded attempted to create an entity framework model file (.edmx).
When doing s...
Management asked 11/9, 2011 at 2:1
3
Solved
I have installed SQL Server 2016 Express edition and also installed SSMS 18.4, now I am having an issue while restarting the SQL Server Agent service.
I am able to login with my system user, but ...
Blastoderm asked 8/11, 2019 at 7:45
9
I have installed the free version of sql server 2008 (sql server management studio express edition) on my PC. After installation I get the following error
create table permission denied in databas...
Rauscher asked 5/9, 2011 at 22:2
3
Solved
I have an SQL Azure database and connect to it in SQL Server Management Studio. I do Export Data Tier Application and then Import Data Tier Application for the .bacpac file to get it into my locald...
Pori asked 4/1, 2021 at 21:27
2
Solved
Original (which works fine) docker file which connects to a SQL Server database in Azure looks like this:
version: '3.4'
services:
my.service:
build:
dockerfile: Test/Test/Dockerfile
environme...
Cerous asked 15/2, 2021 at 14:59
7
Solved
Can any body tel me how to overcome this error when taking a backup in SQL Server 2008 Express?
Backup failed for Server '\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
For help, click: http://g...
Inverter asked 1/8, 2014 at 17:58
4
Solved
I've created this stored procedure which dynamically creates the same trigger for all my tables:
USE [MyDatabase]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--Drop Stored Procedure
BEG...
Cocker asked 6/7, 2014 at 5:51
1 Next >
© 2022 - 2024 — McMap. All rights reserved.