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.
Clear out the application data directory, but the errors return after restarting Toad and running the sproc 2 or more times.
Waiting for fix in a future version of Toad for SQL Server.
Not replicable on all databases and all installs of Toad. May occur in SQL Server 2000 databases also.