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_BlitzLock error #3212

Closed
AlexanderMaizanov opened this issue Jan 10, 2023 · 1 comment
Closed

sp_BlitzLock error #3212

AlexanderMaizanov opened this issue Jan 10, 2023 · 1 comment

Comments

@AlexanderMaizanov
Copy link

When I run this command
[dbo].[sp_blitzlock] @databasename ='databasename'
I got this error:
Msg 8114, Level 16, State 5, Procedure sp_BlitzLock, Line 1762 [Batch Start Line 2] Error converting data type nvarchar to bigint.
This line dow.database_id = @DatabaseName OR @DatabaseName IS NULL in sp_BlitzLock causes the error. Must be changed to dow.database_id = @DatabaseId OR @DatabaseName IS NULL.

@BrentOzar
Copy link
Member

Welcome to Github! When you file an issue, you wanna make sure there's not already an issue about what you're describing. In this case, it's here: #3201

And that issue has already been fixed in the dev branch of the code. You can download that here: https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/blob/dev/sp_BlitzLock.sql

And it'll be in the next release. Cheers!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants