Cr8 & Stored procedure ..Crash ..Crash
am using VB6 ,CR8 and SQL server to generate a report
The report is using a stored procedure with 10 parameters , each of 250 characters lenght ,,,
For small criteria ..(less than 2 Parametres i.e 500 characters ) the report works fine , when I pass about 6 paramters (approximately 1500 characters ...) It Crashes
I tried the Stored procedure with the 6 parameters using the SQL Query Analyzer ...and it works fine ...
What is going on ? Can anyone help ...?!!!