Skip to main content
336,739 questions
Newest Active Bountied Unanswered
-3 votes
0 answers
21 views

After installing SSMS 22 and uninstalling SSMS 21, for an existing linked server (on SQL Server 2022 Express), I get an error message The OLE DB provider "MSOLEDBSQL.19" has not been ...
Mihai Moisei's user avatar
  • 1
0 votes
0 answers
26 views

I am hosting a SQL Server database at a customer and need to run sp_updatestats. My user that has been assigned does have db_owner permissions but they cannot give me sysadmin permissions. From what I'...
Cameron Castillo's user avatar
  • 3,104
-3 votes
0 answers
74 views

I have two tables; the first one consists of clients' names and their id. For example: name surname1 519651 name surname2 496879 name surname3 848465 The second one consists of clients'...
solar dary's user avatar
  • 1
-2 votes
0 answers
84 views

I don't know what's wrong, or if there's a configuration problem. I can execute queries and create new stored procedures, but I can't commit changes to existing stored procedures.I don't know what's ...
jw Luo's user avatar
  • 1
0 votes
1 answer
120 views

I’m migrating SQL Server tables to Snowflake using Azure Data Factory. Direct Copy from SQL Server to Snowflake works, but I can’t use it because of the 100 MB row size limit. That forces me to take ...
Arud Seka Berne S's user avatar
  • 1,001
Advice
1 vote
2 replies
48 views

I am trying to create a visual overview / diagram for an old SQL Server database. I have already looked through similar questions and articles, but I couldn't find a program that suits the task. I ...
simplepoint25's user avatar
  • 1
0 votes
1 answer
102 views

I have an unique filtered index that is not allowing a PO to be inserted and there is no duplicate to be found. How can I allow POs to be inserted that are unique when the index thinks they are ...
Ken Watson's user avatar
  • 1
-1 votes
0 answers
50 views

When we are trying to connect the SSIS (Integration Services) from remote Server, we are getting below error. The SQL Server version is 2019. We are able to connect with SSMS 18 version from remotely ...
Shannu's user avatar
  • 11
0 votes
0 answers
53 views

in our package that we use for connecting to database and perform stuff on it (like read table, insert data, ...) we have a special method that we pass to pandas.to_sql method to insert data to ...
Saguro's user avatar
  • 151
0 votes
2 answers
156 views

I have a query that outputs the below result: users file_consumed John orders Martin orders Alice orders Bob payments Alex payments Julie payments John deliveries Bob deliveries I want to convert this ...
LearneR's user avatar
  • 2,591
0 votes
1 answer
60 views

Unless the query result displays in pretty much less than a second then I get this pop-up notification every single time I execute a query. Is there any way to disable this? I found under Tools -> ...
Fettster777's user avatar
  • 41
0 votes
0 answers
45 views

I’m running an Azure DevOps pipeline on an Ubuntu agent inside a container (rocker/verse:4.0.4). The goal is to push data from R to SQL Server after refreshing some datasets. I installed the Microsoft ...
Ferxani's user avatar
  • 1
1 vote
1 answer
66 views

I have created on SSIS(2019) package. The package is selecting the data from oracles tables in writing it to a flat file (CSV). The package is working perfectly in visual studio (SSIS designer). But ...
Rana_kgec's user avatar
  • 58
3 votes
2 answers
154 views

I am creating a varchar(max) string for submission to 'EXEC' and it is less than 1000 bytes long, yet the 'exec' errors out - seems to not get the entire string. Below is the code that errors out: ...
JackRay's user avatar
  • 53
1 vote
1 answer
175 views

Is it possible to pivot OPENJSON data for multiple rows in T-SQL (on SQL Server 2022). I have a case like below, it works fine for single ID (eg. CustID=111). Surely I can go this route processing ...
user1982778's user avatar
  • 141

15 30 50 per page
1
2 3 4 5
…
22450