Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gageller
Starting Member
2 Posts |
 Posted - 2009-06-16 : 11:55:37
|
| Hi all,I am somewhat of a novice when it comes to stored procedures. I am having trouble debugging a stored procedure. I am receiving the following error "[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification". I think it is on two of the parameters which are datetime data types.When I enter the time parameters into the Debug Procedure dialog box, I enter the time as '01/01/2003' and '12/31/2003'. Is this incorrect?Any help would be greatly appreciated!Thanks in advance.Greg |
|
|
gageller
Starting Member
2 Posts |
Posted - 2009-06-16 : 12:01:34
|
| I have also tried entering the dates as 20030101 and 20031231 but that still did not help |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-06-16 : 12:11:46
|
| Did you get a line number back? or just the unhelpful message.How are you debugging the stored proc? from some application layer or direct through enterprise manager.things to try:Try running the stored proc from query analyser direct.EXEC <storedProc> <paramas>You should get the line number of the fault then -- that will help unless the fault is in a block of dynamic sql. It should isolate the SELECT / UPDATE / whatever that is causing the problem.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
Error when debugging Stored Procedure