is there a describe or show function in SQL server 2022?
Is there a description or show function in SQL server 2022? Or a similar way to do this?
Could two queries share the same parameter/variable?
Could two queries share the same parameter/variable?
SQL server linked server using ODBC - windows vs SQL login
We have an ODBC connection to Netsuite. It uses a CA certificate. I can create a linked server using the MSDASQL provider and it works fine, but only for SQL server logins. For windows logins, behavior is not consistent. Some accounts can use the remote…
Find duplicate rows in SQL
I don't mind the approach but was I was looking for a PO within my database and found duplicate rows. Like, have a way to catch these.
more number of rows in database
HI, How to get view which has more number of rows in to it in sql server database
Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update
Hi MS, We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed. I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version…
MS SQL Server SELECT not showing all fields in tables, how to fix?
We use an Azure Synapse SQL server, which contains a copy of our data from a Postgresql server, and I'm trying to list all the table names and fields in each table and display them in a viz in Power BI. Since I'm doing work in PBI this makes it…
After upgradation of SQL server from 2016 to 2022 we are unable to connect with azure storage account using polybase managed identity.
Hi, We have implemented Poly base mechanism to retrieve data from azure storage to SQL Server. However, we are able to connect with storage account using poly base with SAS token in SQL server 2016. As per the documentation SQL server 2022 supports Poly…
How to connect DB2OLEDB provider data link (SQLSERVER) to one DB2/AS400 with SSL/TLS
Hi there, Target: use DB2OLEDB provider from SQL Server data link to connect to one DB2/AS400 database using port 448 (SSL/TLS) I have one Windows Server 2019 and one SQL Server 2019 installed. I have also instaled Data Access Tool version 7 that…
When following SSIS Tutorial on microsoft learn I receive a data type error
I have following the Microsoft Learn SSIS tutorial and am currently on https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-6-adding-and-configuring-the-lookup-transformations?view=sql-server-ver16 , trying to follow the below step: My…
How to preserve customizations made to views in the 'catalog' schema?
In order to suppress sensitive variables from appearing in the Integration Services Catalogs' execution reports, we have made alterations to views in the 'catalog' schema of the SSIS DB. These customizations are overwritten when SQL Server patches are…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Ho to delete SSRS Reports from Portal, when they don´t exist anymore?
Hi, I´m trying to delete an SSRS Report, which is already not present anymore. I deleted it in already in the Project. But it is still listed in SSRS Portal. when I click on the 3 dots for managing the report I get this error. How to delete the…
Correct way to disable login for SA account??
We need SA to be database owner but reduce potential security issues. I've been told one thing to do is to disable the login permission for the SA account. However, in looking this up I'm confused...everything is t-sql code and it's not clear whether…
Unable to install SQL Server 2022 after uninstalling it. Error: 2147467259
I was having some problems with an older version of SQL Server and SSMS so I decided to just uninstall both of them and try a fresh installation of both. But I get this error 2147467259 message when I try to install SQL Server. Here is one of the files…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Data factory and Dedicated SQL pool with azure pipelines are failing without any issue and it is succeeding with running pipeline multiple times
Hi Team, Azure pipelines are failing without any reason and if we run multiple times it is succeeding. can any one please guide me anything I've to update in azure pipelines.
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
SQL SERVER 2019 STD AG group filling transaction log up
Hi I have a problem with our High Availability environment, since we have upgraded the servers to Windows 2022 datacentre version, Using WSFC the High Availability seems to continually holding the transaction log file open, it grew to 150gb, which I…
Need Macro that will update the date in a sql script entered via GET DATA/SQL in Excel to refresh data in worksheets
I have a sql script that pulls data into a spreadsheet. I need to setup a means for end users to enter a different date into that script and then be able to refresh the output based on the new date.
Unable to connect target database which is onprem MS SQL Server in Datafactory
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: '20.81.184.76 1433', Database: 'Target', User: 'target'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the…
![](https://techprofile.blob.core.windows.net/images/lvNaBJBqh0eurOu4q2bQSQ.png?8DA4E8)
sql server in virtual machine is not starting
After the recent service issue in azure, my sql server in virtual machine is not responding to start/stop. Stuck in provisioning state failed status. Tried reapply and redeploy as well as deallocation. Nothing works
![](https://techprofile.blob.core.windows.net/images/_KR_hQAAAwAAAAAAAAAAAA.png?8D8440)
Error while trying to update Always Encrypted column using a stored procedure
In our development environment, one dedicated machine is set as SQL Server Database server. All other development machines are connected to this server as clients using SQL Server Management Studio. Facing some issues after implementing "Always…