<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/'><id>tag:blogger.com,1999:blog-4762425244190648087.post1751302617789292136..comments</id><updated>2010-03-23T17:58:27.183+05:30</updated><category term='PIVOT'/><category term='Mahesh Dhola'/><category term='Data Flow Task'/><category term='Office 2010 features'/><category term='Derived Column'/><category term='Microsoft'/><category term='SQL'/><category term='For Each Loop Container'/><category term='Query Performance'/><category term='SQL Server'/><category term='Table Variable'/><category term='Compare Database'/><category term='sp_procoption'/><category term='Log'/><category term='Data Transformation'/><category term='SQL PASS'/><category term='Pinal Dave'/><category term='For Each Container Task'/><category term='BULK INSERT TASK'/><category term='Ahmedabad User Group'/><category term='SELECT'/><category term='Event Viewer'/><category term='COALESCE'/><category term='SQL SERVER 2008 R2'/><category term='SQLYoga'/><category term='Presentation'/><category term='OpenQuery'/><category term='Windows7 Features'/><category term='Row Count'/><category term='Tejas Shah'/><category term='CONTEXT_INFO'/><category term='SSIS'/><category term='ORDER BY'/><category term='ActiveX Task'/><category term='ASP .Net'/><category term='Report Viewer'/><category term='Executing queries'/><category term='sp_MSforeachtable'/><category term='SQL SERVER Reporting Service'/><category term='SQL SERVER CENTRAL'/><category term='Transfer SQL Jobs'/><category term='Report Credentials'/><category term='Import Excel file'/><category term='TRUNCATE'/><category term='SQL Server 2005'/><category term='XML'/><category term='EXISTS'/><category term='Auto Execute Stored Procedure'/><category term='Jacob Sebastian'/><category term='Activity Monitor'/><category term='OpenRowSet'/><category term='Comma Separated List'/><category term='Back up'/><category term='SSRS Reports'/><category term='TRANSACTION'/><category term='SQL DateTime'/><category term='Replicate'/><category term='SQL Services'/><category term='Iterate Each Table'/><category term='RDLC'/><category term='SQL Developer'/><category term='SQL Tips'/><category term='SSRS'/><category term='DELETE'/><category term='DotnetChaps'/><category term='DBA'/><category term='CommunityTechDays'/><category term='Harish Vaidyanathan'/><category term='Disaster Recovery'/><category term='T-SQL'/><category term='Cursor'/><category term='Database Mail'/><category term='SSIS Task'/><title type='text'>Comments on SQL Yoga: SQL SERVER: Execute Stored Procedure when SQL SERV...</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://sqlyoga.com/feeds/1751302617789292136/comments/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/1751302617789292136/comments/default'/><link rel='alternate' type='text/html' href='http://sqlyoga.com/2010/03/sql-server-execute-stored-procedure_07.html'/><author><name>Tejas Shah</name><uri>http://www.blogger.com/profile/04041260304854571049</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='26' height='32' src='http://3.bp.blogspot.com/_55yV6koEy_w/Spz2GL70cwI/AAAAAAAAJoA/FDMLzlPcp3A/S220/TejasSmallImage.JPG'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>2</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-4762425244190648087.post-1646637554166247202</id><published>2010-03-23T17:58:27.177+05:30</published><updated>2010-03-23T17:58:27.177+05:30</updated><title type='text'>Hi Kalyan,

This procedure is needed in our produc...</title><summary type='text'>Hi Kalyan,&lt;br /&gt;&lt;br /&gt;This procedure is needed in our production environment where we collect all sql trace into SQL tables. Whenever server is restarted, we need to manually run it and need to make sure that person who restarted services/server should start our performance test.&lt;br /&gt;&lt;br /&gt;To make sure that person has started our performance test or not its not manageable and we cannot make sure</summary><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/1751302617789292136/comments/default/1646637554166247202'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/1751302617789292136/comments/default/1646637554166247202'/><link rel='alternate' type='text/html' href='http://sqlyoga.com/2010/03/sql-server-execute-stored-procedure_07.html?showComment=1269347307177#c1646637554166247202' title=''/><author><name>Tejas Shah</name><uri>http://www.blogger.com/profile/04041260304854571049</uri><email>noreply@blogger.com</email><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='OpenSocialUserId' value='17116247368334096599'/><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='26' height='32' src='http://3.bp.blogspot.com/_55yV6koEy_w/Spz2GL70cwI/AAAAAAAAJoA/FDMLzlPcp3A/S220/TejasSmallImage.JPG'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://sqlyoga.com/2010/03/sql-server-execute-stored-procedure_07.html' ref='tag:blogger.com,1999:blog-4762425244190648087.post-1751302617789292136' source='http://www.blogger.com/feeds/4762425244190648087/posts/default/1751302617789292136' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1639380587'/></entry><entry><id>tag:blogger.com,1999:blog-4762425244190648087.post-8262164090292256064</id><published>2010-03-23T15:36:40.205+05:30</published><updated>2010-03-23T15:36:40.205+05:30</updated><title type='text'>hello shah

what is the main advantage of using th...</title><summary type='text'>hello shah&lt;br /&gt;&lt;br /&gt;what is the main advantage of using this procedure in master database ?&lt;br /&gt;let me explain the situation using this procedure?&lt;br /&gt;&lt;br /&gt;regards&lt;br /&gt;kalyan</summary><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/1751302617789292136/comments/default/8262164090292256064'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4762425244190648087/1751302617789292136/comments/default/8262164090292256064'/><link rel='alternate' type='text/html' href='http://sqlyoga.com/2010/03/sql-server-execute-stored-procedure_07.html?showComment=1269338800205#c8262164090292256064' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://sqlyoga.com/2010/03/sql-server-execute-stored-procedure_07.html' ref='tag:blogger.com,1999:blog-4762425244190648087.post-1751302617789292136' source='http://www.blogger.com/feeds/4762425244190648087/posts/default/1751302617789292136' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1534985317'/></entry></feed>
