-- Update version document name in version history
BEGIN
	DECLARE @nodeXML as nvarchar(max);
	DECLARE @versionHistoryID as int;
	DECLARE @start as int;
	DECLARE @end as int;

	DECLARE @historyCursor CURSOR;

	SET @historyCursor = CURSOR FOR SELECT NodeXML, VersionHistoryID FROM CMS_VersionHistory;

	OPEN @historyCursor
	FETCH NEXT FROM @historyCursor INTO @nodeXML, @versionHistoryID;
	WHILE @@FETCH_STATUS = 0
	BEGIN
		-- Update document name
		SET @start = PATINDEX('%<documentname>%', @nodeXML);
		SET @end = PATINDEX('%</documentname>%', @nodeXML);

		IF @start > 0 AND @end > @start
			UPDATE CMS_VersionHistory SET VersionDocumentName = SUBSTRING(SUBSTRING(@nodeXML, @start + 14, @end - @start - 14), 0, 100) WHERE VersionHistoryID = @versionHistoryID;
		ELSE
			UPDATE CMS_VersionHistory SET VersionDocumentName = '' WHERE VersionHistoryID = @versionHistoryID;

		-- Update document type
		SET @start = PATINDEX('%<documenttype>%', @nodeXML);
		SET @end = PATINDEX('%</documenttype>%', @nodeXML);

		IF @start > 0 AND @end > @start
			UPDATE CMS_VersionHistory SET VersionDocumentType = SUBSTRING(SUBSTRING(@nodeXML, @start + 14, @end - @start - 14), 0, 50) WHERE VersionHistoryID = @versionHistoryID;
		ELSE
			UPDATE CMS_VersionHistory SET VersionDocumentType = '' WHERE VersionHistoryID = @versionHistoryID;
	
		FETCH NEXT FROM @historyCursor INTO @nodeXML, @versionHistoryID;
	END
	CLOSE @historyCursor;
	DEALLOCATE @historyCursor;
END

Failed to run SQLscript: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.