[ lopkiju @ 07.12.2006. 19:12 ] @
Imam problem sa jednom ugnjezdenom procedurom. Kreiram je sa ovim code-om ispod i kada uradim refresh, sp postoji u bazi, cim refreshujem aplikaciju (ASP.NET), prijavi mi Object reference not set to an instance of an object, gresku. Vratim se u MS Server Management, uradim refresh i procedure nema... Jel ja ludim ili ne radim nesto kako treba? Code: if exists(select * from dbo.sysobjects where id = object_id(N'[spForumGetNumberOfPosts]') and OBJECTPROPERTY(id, N'isProcedure') = 1) drop procedure [spForumGetNumberOfPosts] GO CREATE PROCEDURE [spForumGetNumberOfPosts] ( @SubForumId int ) -- WITH ENCRYPTION AS begin select Count(*) as PostsNumber from posts left join threads on posts.threads_id = threads.threads_id where threads.subforums_id = @SubForumId; end -- end spForumGetPostsNum |