Help required with SQL Server
Hi Team, Could you please reply to below 2 points - I have a requirement where I need to identify all windows machines where Microsoft SQL Server is installed (any version). To identify I have gone to control panel of each machine(inside uninstall and…
Cannot alter column because it is 'ROWGUIDCOL'
After restoring a database one of my columns was changed from NULL to newid(). I tried to run ALTER TABLE Table1 ALTER COLUMN Id uniqueidentifier NULL script and I got 'Cannot alter column Id because it is 'ROWGUIDCOL'
Upgrade required
Hi Team, I am having SQL Server 2022 Developer edition on my windows machine. I need to upgrade below (to avoid any security vulnerability) - SQL Server 2022 Developer edition OLEDB ODBC Please let me know the steps(links) for same. Let me know if…
Hash table creation issue in Sql server
I have created hash table in outer procedure with 2 columns and trying to create another hash table with same name but 3 columns. Now if i try to insert into hash table in inner procedure i get error saying not able to access third column (which was not…
SQL managed instance stopped saying I got the vCore 720 reached
I've create a resource of SQL managed instance with the new offer of free vCore 720 hours/month for 12 months. But after 2 weeks the database stopped saying I got the vCore 720 reached. Is that right? I've created just 1 database in the instance. How can…
"Sync to other databases" is missing
Under Data management, select Sync to other databases is missing, I'm the Global Admin / Owner of the Database and Subscription so I think this can't be an access Issue.
can you guys help me, I always get this error when importing management studio sql files.
The given value '24,269' of type String from the data source cannot be converted to type int for Column 7 [rating_count]. (Microsoft.Data.SqlClient) Failed to convert parameter value from a String to a Int32. (Microsoft.Data.SqlClient) Input string was…
SQL Server 2022 Express installation - how to fix 'error while checking Rules of Sql Server set up'?
Hello, I am having trouble installing SQL Server 2022 Express Edition, Basic installation type. I keep getting this error during installation: "There was an error while checking Rules of Sql Server setup" I have so far tried: Restarting my…
Microsoft (R) Visual Basic Compiler asking the upgrade the version.
We are trying to Execute SSRS report using rs.exe and will store result in CSV file. For this We have prepared (.rss) file, and executed from command prompt with following command. rs -i filename.rss -s https://server_name/ReportServer -v…
SQL SPNs for 2 Node AON Cluster with 2x Instances and custom Ports
Hi everybody, I read so many different suggestions in different forums and blog artciles that it made me question my understanding about the proper SPN registration for SQL. I have a pretty standard setup: 2 Node Cluster consisting of: …
How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11
Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…
Can a deadlock issue be raise while running two select queries in sql server
Do we get a deadlock issue while running two select statements of two different table in sql server
exit code (decimal): -2068052377error description: invalid command line argument. consult the window installer sdk for detailed command line help
This morning I was still able to use sql, I was curious and deleted something like SQLEXPRESS16, then I uninstalled all sql and reinstalled it all, and used quite a few cmd commands that I didn't know to uninstall but still nothing. I can't remove them,…
SSRS Report Server 22 Native Scale Out with a network Load Balancer not working as expected.
I have setup a 2022 SQL Instance. Using the DB from a 2012 r2 instance. I have looked over documentation. I can only get the last report server joined to the instance to display the webserver and the reports server. Example node1, 2 and 3 were installed…
Seeking Expertise in Spark SQL CTE Recursive Queries in Azure Databricks
I'm currently diving deep into Spark SQL and its capabilities, and I'm facing an interesting challenge. I'm eager to learn how to write CTE recursive queries in Spark SQL, but after thorough research, it seems that Spark doesn't natively support…
In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role.
In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role. If yes then what is that. Do I need to install SQL…
Hyper-V replica - EnableWriteOrderPreservationAcrossDisk for SQL VM not working
According to Support policy for hardware virtualization product - SQL Server | Microsoft Learn, Hyper-V replica for a VM running SQL server is a supported scenario as long as you enable EnableWriteOrderPreservationAcrossDisks as described in the…
Connecting Azure web app service (.net8) to SSRS on Azure VM by using private DNS
My azure web app service(.net8) connect to SSRS on VM by using the private DNS name provided by Azure to the VM, but my credentials did not work when I run the report on my azure web app server. The private DNS name works fine with my credentials via url…
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
Quick Connection to SQL Server in Management Studio
Hello, I am using Management Studio to manage my databases, and I have multiple servers with several different databases. Is there a way to avoid having to enter the server name and user name every time? Perhaps by presetting all connection settings?