Create table with Memory_Optimized=true

hari prasad 1 Reputation point
2023-03-03T09:45:35.08+00:00

Msg 596, Level 21, State 1, Line 4
Cannot continue the execution because the session is in the kill state.
Msg 0, Level 20, State 0, Line 4
A severe error occurred on the current command.  The results, if any, should be discarded.

Getting below error while creating the table ...Please suggest me to achieve the requirement

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 7,966 Reputation points MVP
    2023-03-03T11:50:28.9566667+00:00

    Hi Hari

    Welcome to Q&A Forum, this is a great place to get support, answers and tips.

    Thank you for posting your query, I'll be more than glad to help you out.

    Mayb it is because someone killed your session as the error message suggests?

    Cannot continue the execution because the session is in the kill state.

    Seems someone wether killed your session or sql server engine was shutting down during your execution of the create statement.

    Have you tried again? Do you received the same or a different message?

    To support your question in a better way it might be helpful to see the complete statement which you executed... so please sent the DDL statement which you tried to execute.

    Thank you.

    I hope my answer is helpful to you,

    Your

    Bjoern Peters

    If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

  2. Seeya Xi-MSFT 15,036 Reputation points Microsoft Vendor
    2023-03-06T05:54:45.8966667+00:00

    Hi @hari prasad,

    You can check for syntax errors.

    https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/creating-a-memory-optimized-table-and-a-natively-compiled-stored-procedure?view=sql-server-ver16

    Also, you can check the methods of troubleshooting in this thread.

    https://stackoverflow.com/questions/40449982/cannot-continue-the-execution-because-the-session-is-in-the-kill-state-while-bu

    Best regards,

    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".