Oct 8, 2001 #1 GRHE Programmer Jun 19, 2001 29 GB HI Is there an argument to stop it displaying (213 rows affected) ??? Cheers
Oct 8, 2001 #2 salma Technical User Aug 21, 2001 13 GB run the following command at the start of the query set nocount on note this command is 'sticky' which means it lasts for the session Upvote 0 Downvote
run the following command at the start of the query set nocount on note this command is 'sticky' which means it lasts for the session
Oct 8, 2001 #3 tomschafer Technical User Aug 9, 2001 474 US Add this to the top of your SQL batch... set nocount on Upvote 0 Downvote
Oct 8, 2001 Thread starter #4 GRHE Programmer Jun 19, 2001 29 GB works like a dream - great cheers Upvote 0 Downvote