After upgrading SQL Server 2005 to SP2, trying to run sprocs with varchar parameters via Toad but getting an error. When selecting the value field of varchar in the Set Parameters window, when trying to modify the values, consistently, the 2nd field selected, following error is given. The same sproc run fine if run through visual studio or sql server mgmt studio.
Positive number required.
Parameter name: culture
In the Browser | Programmability | Stored Procedures, choose a proc and right click | Run. This will bring up the set parameter window. The proc has 3 parameters (two of which are varchar):
You click on the value field of col_6. No error. Then you click on the value field of col_4... error. You can click on col_5 or col_6 as much as you want, but from then on, if you click on col_4 you will always error out. It does not matter which varchar you start with (col_6 or col_4). Which ever you click second will always error out. Note, it does not seem to be a problem for data types other then varchar. The nvarchar example here never errors out.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.