Please refer tohttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20826 post for updated code. Michael B Sr. DBA "The fear of the Lord is the beginning of knowledge, but fools despise wisdom and instruction." Proverbs 1:7
I see some proprietary code in the procedure. you can probably remove that. Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
Roji<br />If you think so then its better to contact Michael in this case [<img src='/community/emoticons/emotion-5.gif' alt='' />], until then this is spared.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>
I was talking about this particular section of code. &**** code has been corrected. Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
quote:Originally posted by Roji. P. Thomas I was talking about this particular section of code. ***** Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com Agreed. This section should be removed. KH
Satya, instead of removing those lines, can you strike out them so that others can know what and where it was placed [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
Rather I would get Mike to change or replace with relevant values, as this is his post to provide such helpful information. I have emailed him anyway in this regard, so we should see the relevant changes. Thanks guys. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
fixed. sorry.. I didnt look back at this for a while. Michael MCDBA "The fear of the Lord is the beginning of knowledge, but fools despise wisdom and instruction." Proverbs 1:7
Satya, can you stike the other responses since code is in there and just make it a fresh one? or I can repost. sorry for the issue. I did not see that in there. Michael MCDBA "The fear of the Lord is the beginning of knowledge, but fools despise wisdom and instruction." Proverbs 1:7
Well for the sake of your requirement what you can do is post a fresh one with code, then refer this post to that thread. Meanwhile I will move this to appropriate section. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
I have created the new one.. please drop this one. Thanks! Michael MCDBA "The fear of the Lord is the beginning of knowledge, but fools despise wisdom and instruction." Proverbs 1:7