Write-Host || Cannot invoke this function because the current host does not implement it
Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...
2017-02-01
1,464 reads
Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...
2017-02-01
1,464 reads
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...
2017-01-23
1,042 reads
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules...
2017-01-16
562 reads
As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to...
2017-01-05
472 reads
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
401 reads
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
369 reads
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
446 reads
SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File...
2016-12-12
2,615 reads
Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB...
2016-11-30
861 reads
After lots of crisis in last month, We are back again.
Sorry for inconvenience caused !
Reference : Rohit Garg (http://mssqlfun.com/)
You can find...
2016-11-15
515 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers