Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sp_BlitzFirst: Remove @@ROWCOUNT to prevent errors while server is starting up #3237

Closed
BrentOzar opened this issue Mar 2, 2023 · 0 comments · Fixed by #3238
Closed

sp_BlitzFirst: Remove @@ROWCOUNT to prevent errors while server is starting up #3237

BrentOzar opened this issue Mar 2, 2023 · 0 comments · Fixed by #3238
Assignees

Comments

@BrentOzar
Copy link
Member

Version of the script
SELECT @Version = '8.13', @VersionDate = '20230215';

What is the current behavior?
If you run sp_BlitzFirst while SQL Server is first starting up, AND it's recovering an In-Memory OLTP database, the @@rowcount will fail.

What is the expected behavior?
Run without failing. The fix is actually easy here - I'll switch the @@rowcount to an existence check in the table we just inserted into.

Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
All versions.

@BrentOzar BrentOzar added this to the 2023-05 Release milestone Mar 2, 2023
@BrentOzar BrentOzar self-assigned this Mar 2, 2023
BrentOzar added a commit that referenced this issue Mar 2, 2023
To prevent startup problems with Hekaton. Closes #3237.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant