1,740 questions
0
votes
0
answers
113
views
sqlcmd cannot connect to LocalDB (MSSQLLocalDB) even though instance is running
I have a fresh installation of SQL Server 2022 LocalDB.
When I try to initialize a database with a script using the command:
sqlcmd -S (localdb)\MSSQLLocalDB -E
I get the following error:
No named ...
-1
votes
1
answer
104
views
Add a 3rd table after an 1st table OUTER APPLY 2nd table [closed]
I have a SQL script written by someone that uses outer apply on a function. I think a code generator WYSIWYG was used , I thought that all the CAST's was making it more stable, but apparently just ...
0
votes
0
answers
29
views
InstallShield issue SUPPORTDIR using
I encountered the following issue in InstallShield 2016: I'm trying to use SUPPORTDIR to place my executable file there.
However, when I open the SUPPORTDIR folder (e.g., C:\Users\user-name\AppData\...
0
votes
0
answers
47
views
Install SQL Server Express using InstallShield
I have a question and I need help solving an issue.
I have an installshield 2016 installation and I want to allow the user to either select an existing SQL Server database (and then the installation ...
1
vote
1
answer
65
views
VB.NET winforms SQL Server Express - aggregate query to variable
I've searched again and again. Have a solution but must be easier way.
Currently, I'm writing a SQL command to cycle through records for min value as first using the code below. As you can see, I am ...
1
vote
1
answer
44
views
SQL-Express 2019: Restore Multiple .BAK Files as individual Databases
I have to restore a SQL backup from someone external and have the following issue:
Instead of making a nice single big file for the entire instance of SQL, I have a folder with 100+ individual ...
0
votes
1
answer
423
views
SQL Server 2022 Express logs the message: RBPEX::NotifyFileShutdown: Called for database ID, database not accessible
Our SQL Server log contains multiple messages for every database installed in the instance:
RBPEX::NotifyFileShutdown: Called for database ID....
There is no error message about this in the window ...
0
votes
1
answer
112
views
Create named instance in SQL Server Express
I'd like to pull some data into SQL Server Express, from a high-current electrical test machine running SQL Server.
The first problem I'm experiencing is that I can't get replication setup, because ...
0
votes
0
answers
32
views
ASP.NET MVC upload an image and save it to database
I am trying to upload an image to save it to SQL Server Express.
This is my view:
@model Nettbutikk.Models.ProductsModel
@{
}
@Html.Raw(ViewBag.msg)
@using (Html.BeginForm())
{
@Html....
0
votes
1
answer
49
views
ASP.NET MVC : display image on view
I am trying to display an image in a view.
Here I add an image in SQL Server Express (price is defined as int and picture is a varbinary(MAX) column):
insert into products (price, picture)
select ...
1
vote
1
answer
131
views
Format of the initialization string does not conform to specification - using same string for EF that worked for SqlClient
I am transitioning from code that uses Microsoft.Data.SqlClient to Microsoft.EntityFrameworkCore in .NET Core 8.0. I have a connection string that successfully connects to a local SQL Server Express ...
0
votes
1
answer
50
views
Changes not showing in local SQL Server Express database after Razor Page form submission
I'm trying to connect to a local SQL Server Express database, but when I submit a form using my .cshtml.cs page, the data doesn’t appear in the table after the command executes. I’m not sure if this ...
1
vote
0
answers
230
views
ASP.NET Core 8 SignalR and Angular 8 integration: no messages after SQL Server database changes
I’m currently working on a project involving an ASP.NET Core 8 application with SignalR for real-time notifications with SQL Server,
an Angular 18 frontend, and SQL Server 2022 Express edition as the ...
0
votes
0
answers
214
views
How to fix SQL Server Management Studio install on Windows 7 SP1?
I am learning SQL Server on my Windows 7 Laptop. And I am trying to install SQL Server Management Studio, I have already installed SQL Server Express and Local DB.
Whenever I try to install SSMS on my ...
0
votes
0
answers
40
views
checking if SQL Express installed in Inno Setup [duplicate]
I am trying to figure out that SQL Express is installed on Machin in Inno Setup. so I did this
res:= RegQueryStringValue(HKLM, 'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL', 'SQLEXPRESS'...