November 19, 2021 at 1:21 am
My OS is Windows server 2008 R2 enterprise, and SQL Server is 2008 R2 standard edition, I created more than half year, It ran without any error before this week, but it failed to run sometime since this week. even if I start SQL Server Agent service using NT SERVICE\MSSQLSERVER or NT SERVICE\SQLSERVERAGENT account, the case is same ( most time runs ok, but sometimes it is ok)
how can I do the troubleshooting? thanks !
November 19, 2021 at 1:29 pm
Read the full error message. It says something about incorrect number of parameters. Without seeing your code or the message or anything else, I can't tell you what's going on, but I can say, read the error. Understand what it is saying, then figure out where in your code you've gone wrong to cause that error. That's it. Troubleshooting 101. Read the error message.
----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply