August 19, 2009 at 4:37 am
whenever I create\alter a store proc in my server I got "1 rows affected" in the result panel instead of "commands completed successfully". I got this message for only one database since my server has many databases. When I do the same thing in other database I got "commands completed successfully". Can any one assist me on this?
Thx.
August 19, 2009 at 5:01 am
have you got a DDL trigger on CREATE/ALTER?
August 19, 2009 at 5:02 am
No, we don't have any trigger
August 19, 2009 at 5:07 am
You don't have a 'GO' somewhere in the proc do you?
Could you post the code that you are using to create/alter?
August 19, 2009 at 5:24 am
alter PROCEDURE test
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
select 1
END
go
August 19, 2009 at 5:32 am
in the database where you get the message, can you run these and post the results
select * from sys.server_triggers
select * from sys.triggers
August 19, 2009 at 5:54 am
I have a Database trigger and it throws the above said message. Just now I updated the NOCOUNT value is ON and got the right message. Thanks for your earliest reply!!!
August 19, 2009 at 5:59 am
No problems - glad we got there in the end!
I did wonder when you said 'no, we don't have any trigger' whether that meant ' I haven't added any triggers' or 'I don't know of any triggers' 🙂
Kev
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply