tag:blogger.com,1999:blog-6818257984018916419.post6581815945487989537..comments2024-01-26T06:00:42.884-08:00Comments on Jon Morisi's SQL Blog: Alert Based Automation of WhoIsActive with XML attachmentJon Morisihttp://www.blogger.com/profile/11048505964243402700noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6818257984018916419.post-32046861037121587412015-07-27T20:50:22.054-07:002015-07-27T20:50:22.054-07:00hi jon, Upon running in ssms this script i got an ...hi jon, Upon running in ssms this script i got an error.<br />----------------------------------------------------------------------------------<br />EXEC sp_WhoIsActive<br />@find_block_leaders = 1,<br />@output_column_list=<br />'[start_time][sql_text][session_id][login_name][CPU%][block%][reads%][writes%][wait_info][open_tran_count][database_name]',<br />@format_output = 0,<br />@destination_table = 'WhoIsActive'; <br />-------------------------------------------------------------------------------<br />Warning: Null value is eliminated by an aggregate or other SET operation.<br />Msg 213, Level 16, State 1, Line 1<br />Column name or number of supplied values does not match table definition.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6818257984018916419.post-42341631718290157212014-04-15T09:27:02.426-07:002014-04-15T09:27:02.426-07:00Jon, great article- exactly what I needed. I was g...Jon, great article- exactly what I needed. I was getting an "illegal qualified name character" with the data type of the sql_text field as XML, so I changed the data type of that field in my whoisactive table to text which resolved it. Obviously, I couldn't use the XML stuff in step 4 and later, but that's OK for my particular situation. Thanks!Scott Petersenhttp://www.datawisdoms.comnoreply@blogger.com