| Author |
Topic |
|
vbjohn
Starting Member
32 Posts |
 Posted - 2003-04-10 : 16:17:28
|
| Is there a limit on Stored Procedures?Cause we have a lot of Stored Procedures and if I added one more I get an error CRW32.exe and closes down my program in Crystal Reports.John- |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-04-10 : 16:27:43
|
| The limit must be in Crystal Reports, not SQL Server. In SQL server, you can have 2 147 483 647 objects in one database.On a side note, have you remembered to do SET NOCOUNT ON in your procedure? It's very important if the procedure consists of more than one statement. Crystal Reports cannot handle that. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-04-10 : 18:23:01
|
Yeah SET NOCOUNT ON is super important with Crystal Reports. Another important tip is any VARCHAR field larger than 255 will be trimmed to 255 characters. TO prevent this, do the following: SELECT field1, field2, CAST(myBigVarCharField AS TEXT) as myBigVarCharField FROM MyTable Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
vbjohn
Starting Member
32 Posts |
Posted - 2003-04-11 : 09:48:30
|
| I did not have... SET NOCOUNT ON.. So I put the in the Stored Procedures. and still the Crystal Reports is giving me the error. I should contact CRYSTAL REPORTS tech help about this.John- |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-04-11 : 13:54:47
|
| Maybe it's the "one extra" SP that the problem is with....Does it matter what SP you add in....ie does it fail with all SP's or just 1 particular SP? |
|
|
|
vbjohn
Starting Member
32 Posts |
Posted - 2003-04-14 : 11:18:12
|
| When I enter in any stored procedure. No matter how simple or complicated the stored procedure is.John- |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-14 : 12:34:04
|
| did you check out my original post at the site specified...they point to configuration on your box most likely.Brett8-) |
|
|
|
vbjohn
Starting Member
32 Posts |
|
|
|
Limits On Stored Procedures?