This is going to be a quick reference for people encountering this error and to do the fix more than a blog post but I do show a small trick on how to do an UPDATE in chunks 😉 The Error: I ran into this error with (Microsoft SQL Server 2012 (SP4-GDR) (KB4057116) - 11.0.7462.6 … Continue reading SQL Server: Fix Msg 8630, Level 16, State 1, Line 1 – Internal Query Processor Error: The query processor encountered an unexpected error during execution (HRESULT = 0x80040e19).
Tag: State 1
SQL Server: Fix – The server principal “elevated_user_login” is not able to access the database “my_database” under the current security context
The Error: This error wasted my morning. Although I have solved this issue before, it took a while to google and fix it again. So, this post is for my own edification and reference if for no other reason! --Proc [MyProcedureName] started AT:2020-10-13 09:49:43.4632735Msg 916, Level 14, State 1, Procedure MySchemaName.MyProcedureName, Line 31 [Batch Start … Continue reading SQL Server: Fix – The server principal “elevated_user_login” is not able to access the database “my_database” under the current security context
SQL Server: Run A Script In Command Line Mode (SQLCMD) Inside SQL Server Management Studio (SSMS)
In mature IT shops, all deployment scripts in a release are run into the database using command-line batches as opposed to doing it by hand. Error running SQLCMDÂ scripts in SSMS Occasionally, when one is testing a single script within a release to make sure it works, he/she needs to jump to the command line to … Continue reading SQL Server: Run A Script In Command Line Mode (SQLCMD) Inside SQL Server Management Studio (SSMS)
SQL Jana 