I have a server running solidcp, version 1.4.0. When I tried to renew the SSL certificate it gives the below error. Object reference not set to an instance of an object. Upon further I have tried to delete the current certificate and install a new Let’s encrypts certificate but was not able to install it. ..
My requirements are that 1 when user see this data fetched by database in windows form he can reorder rows 2 He can change any value, when he change the calculation must be applied to other columns. so tell me where I have to put formulas in database? or in c# ?and how? Source: Windows ..
I’m migrating a SQL Server 2008 database to SQL Server 2019, I have used Microsoft Data Migration Assistant, to look for search any breaking changes, issues or syntax errors. I getting errors for some of my procedures: Object [dbo].[PROCEDURE1] has syntax errors. Must declare the variable or parameter "@SINI". Error number 70590. For more details, ..
I am attempting to use OTL to do a basic insert into a sql server db. For this insert I don’t need to bind any parameters. otl_stream o_stream; std::string query = "INSERT INTO common VALUES (1,2,3);"; o_stream.open(1, query.c_str(), db_); o_stream.flush(); o_stream.close(); However, even after flushing and closing the otl_stream, the db is locked on that ..
How does SQL Server lock pages in memory? Does it use VirtualLock? Source: Windows Que..
I need to make a Desktop Application that will be using .NET on the frontend and SQL Server Express edition as the backend. I need to make sure that this application works even if the internet goes down. How should I make this application working in offline mode? Please keep in mind that this application ..
Testing SQL queries with large datasets against Azure SQL server may be costly, so it is better for me to test my code against a local server. I would like to create a new local server with "SQL Server authentication" rather than "Windows authentication", and I would like to keep my default local server that ..
I have 2 DLL files that inserted on the BINN folder inside SQL Server 2012. One file is called mydllfile.dll, the other one is called mydllfile2.dll Then, I created an extended stored procedure using the query exec sp_addextendedproc N’xp_NewRecid’, N’mydllfile.dll’ This names are sample names just for the sake of the question. The problem is ..
I run this script to list backup files older than 8 days and delete them in a server, and it behaving weird recently. Please see below ::Find backup files older than 8 days ::/p Specifies the path from which to start the search. ::/s Instructs the forfiles command to search into subdirectories recursively. ::/d Selects ..
I am trying to open a link, that link works fine but when i hit login after putting my credentials it lands me to this error. Please help . Server Error in ‘/’ Application. The network path was not found Description: An unhandled exception occurred during the execution of the current web request. Please review ..