Viewing 3 posts - 1 through 3 (of 3 total)
'%_Old%' won't find what you intend it to find. The underscore means "any character". The literal value needs to be '%[_]Old%'.
March 18, 2024 at 9:28 am
Given that you have dbatools installed, there is an easier way to include parameters:
Invoke-DbaQuery -SqlInstance localhost -Database AdventureWorks2017 -Query "[dbo].[uspGetBillOfMaterials]"
-CommandType StoredProcedure -SqlParameter @{StartProductID...
December 23, 2022 at 9:23 am
Given that SQL Server is expensive and licensed by the CPU core, why would you waste CPU on running the SQL Server Agent?
I prefer to have a second computer that...
December 23, 2022 at 9:12 am
Viewing 3 posts - 1 through 3 (of 3 total)