Category : sql-server

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, ..

Read more

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 ..

Read more

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 ..

Read more

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 ..

Read more