I did not know about the article you mentioned. I was trying to find a solution to split a string without looping and also want to split string from a...

Thank you all for your comments. Looks like lot of people are intrested in "making table readonly". Here are some of my reply to some of the comments so far.

1)...

I have fixed both the schema name and computed column issues and did some quick test. Looks fine now. The new change is posted back (the full script code and...

Thank you for checking and using this stored procedure.

I noticed issue 1) before and it is a very simple fix. We need to add the schema name in the dynamic...

Hi Filipe,

Thank you very much for your comment.

1) You are right, this is the limitation and the input string @string should be of type varchar(2047) instead of varchar(8000). If the...

Hi Anthony,

Thank you so much for your feedback and information.

I did not know PartitionManagement.exe before. It is indeed a very useful tool which should be provided by SSIS team.

I write...

The exact list of requirement for partition switch seems very long:

http://msdn.Microsoft.com/en-us/library/ms191160(v=sql.105).aspx

That is exactly one reason I am trying to come up with this sp to hide/deal with these...