Hi Terry,

Thanks for the article!

In a data warehousing environment with larger data I am always looking for ways to enhance the query performance. I have to put your approach into...

Thanks Peter,

Yes you are...

Hardy21 (10/10/2010)

---

Andrew Novick (10/9/2010)

---

Yes, it's a problem. I submitted an item on Connect

https://connect.microsoft.com/SQLServer/feedback/details/398203/sp-rename-doesnt-change-the-text-of-udfs-or-procs-sp-helptext-then-returns-a-script-with-the-old-name

and it was classified as "Won't Fix"

It's something we're going to have to live with.

Regards,

Andy

Andrew Novick

SQL...

Andrew Novick (10/9/2010)

---

Yes, it's a problem. I submitted an item on Connect

https://connect.microsoft.com/SQLServer/feedback/details/398203/sp-rename-doesnt-change-the-text-of-udfs-or-procs-sp-helptext-then-returns-a-script-with-the-old-name

and it was classified as "Won't Fix"

It's something we're going to have to live with.

Regards,

Andy

Andrew Novick

SQL Server...

Thanks!

Yes it's good to always...

Thanks for reading it!

UMG Developer (10/7/2010)

---

Nice article, I think it is good to bring light to this situation.

However, I think it is interesting that you only found the problem because of bad data...

Agreed. DROP/CREATE is also easier to be put in a script

Yes after the re-name has occured if you alter procedure then it will update the syscomments

I don't think you rename a stored procedure using 'ALTER PROCEDURE ...'

We achive the same using an 'execute_all' role that has permission execute on all SPs. We just need to update the role in that case.

I didn't get a chance to test it on 2008. Thanks for trying that as you said it is nice to know

Thanks everybody,

Recently I was reading an article suggesting to actually create a single index on the columns to be updated. Pre-sorting the file also helps a lot.

I am going to...

Hi,

Thanks for quick reply and sorry if my question was vague its just I am not very experienced with large datasets but willing to learn good techniques and practices.

Width of...

Thanks Jamie.

Actually I was working on this but I was not quite sure if there is any other way to do it from (e.g. From code) or not. But you made me...