I'm trying to run the sp_BlitzFirst stored procedure (using the 7/15/2016 version) with the @AsOf parameter, and I'm getting this error:
EXEC sp_BlitzFirst @AsOf = '2015-02-23 18:45', @OutputDatabaseName = 'DBA', @OutputSchemaName = 'dbo', @OutputTableName = 'BlitzFirstResults'
Setting up configuration variables
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
The SQL server version is 11.0.6020.0 (X64).
I used the example query from the documentation page and got this. It's choking on the triple ''' when trying to cast @AsOf to a varchar.
I've worked around this for now, but the documentation said to post here about errors thrown!
@AsOf = CONVERT(DATETIME, '2015-02-23T18:45:00.000')
- this sounds like a localization issue. What locale are you using? What collation is used in this SQL Server instance?