April 18, 2005 at 5:38 am
Does your stored procedure depend on a view?
If the structure of the underlying tables for a view alter then the view can get confused as to which columns to retrieve. Try sp_refreshview on any views and sp_recompile on your stored procedure.
April 19, 2005 at 6:36 am
Are you inserting like this??
Insert into dbo.MyTable (Col, Col2, Col3) exec dbo.MySP
..cause if you're not specifying the columns of the insert you can have a lot of problems.
April 19, 2005 at 6:55 am
...cause if you're not specifying the columns of the insert you can have a lot of problems
Even more problems than the use of a cursor will cause?
What about getting rid of the cursor in the first place?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 19, 2005 at 6:58 am
Forgot to mention that... I gues it's a given to me by now...
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply