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 |
|
kj
Starting Member
1 Post |
 Posted - 2005-08-29 : 23:43:57
|
| Hi! I have a cursor code in storedprocedure, which reads data from a table and inserts into different database table. When I execute this stored procedure from query analyser, it inserts data properly. But if I run stored procedure from DTS it inserts few of the records and stops. It does not give me errors or no failing at DTS. I checked in Profiler but no clue.Can anyone help.RegardsJK |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-30 : 05:41:21
|
| Post the code for us to have a look at it....cursors are avoided here like the plague.Maybe we can convince you of a better SQL method. |
 |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2005-08-31 : 02:53:26
|
| I second that...Almost always (I should be saying, Always), there is a better SQL method to cursors, especially in MS-SQL Server.Hemanth GorijalaI Came. I Saw. I Normalized. |
|
|
|
|
|
|
Cursor does not work in DTS