TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
swati agrawal
NA
20
98k
store procedure showing error
Apr 1 2011 7:00 AM
I have a sp .when m executing it showing message Command(s) completed successfully. but when m calling it showing error dat is
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
sp is given below .plz help
alter PROCEDURE Search
@General varchar(50)
--@country varchar(50)
AS
BEGIN
declare @tbl1 as table (name varchar(50),Id int,discription varchar(100),profilePic varchar(50),comments varchar(50),DateProfileCreate varchar(50),email varchar(50),Category varchar(50),country varchar(50),TypeU varchar(50))
declare @countArtist int
declare @countVenue int
set @countArtist=(select count(*) from tbl_artists where tbl_artists.name like '%@General%' or discription like '%@General%')
set @countVenue=(select count(*) from tbl_venues where tbl_venues.name like '%@General%' or discription like '%@General%')
if(@countArtist >0) and(@countVenue =0)
begin
insert @tbl1 (name ,Id ,discription ,profilePic ,comments,DateProfileCreate,email,Category,country,TypeU)SELECT tbl_artists.name,tbl_artists.ArtistId,tbl_artists.discription, tbl_artists.profilePic, tbl_artists.comments,convert(varchar(50),tbl_artists.DateProfileCreate,105)as DateProfileCreate, tbl_artists.email,tbl_artists.Category,tbl_artists.country,(tbl_artists.Type) as TypeU FROM tbl_artists where tbl_artists.name like '%@General%' or discription like '%@General%'
end
select count(*)from @tbl1
End
Reply
Answers (
2
)
Use RESTORE FILELISTONLY to list the logical file names.
Reduce ldf file size