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 |
|
freesoul
Starting Member
35 Posts |
 Posted - 2007-08-14 : 06:39:52
|
| Getting error Converting DataType forn Varchar to smalldatetimewhen running a job (in SQL Server 2005 ) which calls a SP in the step...this worked fine in SQL Server 7the step is like this ....exec spGet_Prism_Sales_History 'ABC', '2006-09-01', '2006-09-31', 1 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-14 : 07:12:20
|
| That should beexec spGet_Prism_Sales_History 'ABC', '2006-09-01', '2006-09-30', 1MadhivananFailing to plan is Planning to fail |
 |
|
|
freesoul
Starting Member
35 Posts |
Posted - 2007-08-14 : 09:34:34
|
| I did that change and tried to run it again , but again getting the same error ... Error converting data type varchar to smalldatetime. [SQLSTATE 42000] (Error 8114). The step failed.thanks for the reply .. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-14 : 22:49:54
|
| What's default date format on the server? |
|
|
|
freesoul
Starting Member
35 Posts |
Posted - 2007-08-17 : 09:52:58
|
| Thanks it got solved , it was what Madhivanan told ....thanks a lot everyone |
|
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-17 : 10:13:44
|
| Good Eye Madhivan!-----------------------------------------------------------------------------------------------Ashley Rhodes |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-18 : 01:16:48
|
quote:
Originally posted by ashley.sql
Good Eye Madhivan!-----------------------------------------------------------------------------------------------Ashley Rhodes
Thanks  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Error Converting DataType forn Varchar to smalldat